search

stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.
MIT License
9.73k stars 1.57k forks source link

Upgrade to SQLite 3.24.0 #833

Closed jaredrada closed 3 years ago

jaredrada commented 6 years ago

Are there any plans to upgrade to SQLite 3.24.0? I'm aware this version was very recently released however there is a feature I'm keen to use: Support for additional custom columns in Rtree tables. This makes it significantly easier to deal with Rtrees for geospatial applications.

https://sqlite.org/rtree.html

jberkel commented 6 years ago

With cocoapods you can easily use any recent version of SQLite3 together with SQLite.swift. Or do you specifically mean Swift support/wrapping of these new features?

jaredrada commented 6 years ago

Is there a way to specify this version of SQLite w/o Cocoapods? I imported the project manually. I dont expect thered be any changes on the SQLite.swift front to support this (and if there were I'd simply make sure of its ability to execute raw SQL- at least in the mean time). The changes simply allow you to insert more columns when creating the table. Cheers and thanks for a great lib!

jberkel commented 6 years ago

If you integrate SQLite directly you can specify the version yourself, however there are currently no instructions for that.

ChrisChares commented 5 years ago

I'm having some issues trying to directly integrate sqlite3 (and spatialite) with SQLite.swift. @jberkel do you know of any resources anywhere that document this process?

Edit: I got it working. You can more or less just include your own sqlite3 build and go with the caveat that you need this commit which is not in the latest release.

Specifically this change in Sources/SQLiteObjc/include/SQLite-Bridging.h

- #import "sqlite3.h"
+ @import SQLite3;

Side note: looks like iOS 12 ships with sqlite3 v3.24.0.

jberkel commented 3 years ago

fixed, closing