Lighter icon indicating copy to clipboard operation
Lighter copied to clipboard

Swift APIs for SQLite: Type-safe down to the schema. Very, very, fast. Dependency free.

Results 17 Lighter issues
Sort by recently updated
recently updated
newest added

As soon as an aggregate function is used, SQLite seems to loose the type affinity of the expression, e.g.: ```sql CREATE TABLE fun ( value INT ); CREATE VIEW fun_sum...

bug

This can very quickly become non-Light, and maybe it shouldn't be actually done, but it might be useful to have a simple notification center that can broadcast DB change notifications....

question

Instead of shipping the database, the database itself could be generated as Swift code, like: ```swift struct Person: Identifiable { let id : Int let name : String } let...

enhancement

Instead of heaving to create a view like this: ```sql CREATE VIEW fun_sum AS SELECT SUM(intCol) + SUM(doubleCol) AS lol FROM fun; ``` It would be nice if `sqlite2swift` could...

enhancement

I'd be very interested to see support for including open source extensions to sqlite, such as [SQLCipher](https://github.com/sqlcipher/sqlcipher).

enhancement

Your package looks outstanding. Thank you. I would like to use it to replace GRDB in my current app development. I followed the getting started steps but instead of using...

question

Not quite sure how that would look like. Presumably we'd detect the column type `JSON` and then allow SQLite JSON operations on it? How would it look in the associated...

enhancement
question

It would be nice to detect FTS tables and do special things with them. I.e. also omit FTS backing tables from Lighter schemas (they need to be included in schemas...

enhancement

Instead of basing the thing of a SQLite schema, with the new Macro feature in Swift 5.9 we could also generate the metadata required from the Swift structure itself. It...

enhancement

Wouldn't be hard to auto-generate copy-on-write structs, such may be more efficient for dealing with larger records naively.

enhancement