revori
GRDB.swift
revori | GRDB.swift | |
---|---|---|
1 | 37 | |
10 | 6,505 | |
- | - | |
0.0 | 9.3 | |
over 9 years ago | 3 days ago | |
Java | Swift | |
GNU General Public License v3.0 or later | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
revori
-
Ask HN: Is there a way to subscribe to an SQL query for changes?
I've implemented a RDBMS that supports this [1]. It handles joins, views (which are automatically materialized and incrementally updated), etc. It's memory only, and it doesn't support exotic stuff like recursive CTEs, but it does exactly what you're asking for. We used it in production successfully for frequently-updated real time data at the company where I used to work.
Notably, it uses persistent search trees such that each revision shares structure with the previous one, which makes diffing two closely-related revisions extremely efficient (just skip over any shared structure). Subscribers just receive a stream of diffs, with backpressure handled automatically by skipping over intermediate revisions. See [2] for a more detailed summary.
It also exposes revisions as first-class objects, which allows you to tag and diff them. Specifically, you can run arbitrary queries on both revisions and diffs. See [3] for examples.
It's no longer maintained, unfortunately. Someday I may revive it, perhaps adding support for spilling data that won't fit in memory to log-structured merge trees. I'd also rewrite it in a language like Rust, which will help flatten some of the more pointer-heavy data structures and reduce tail latencies. If anyone is interested in seeing that happen or helping out, let me know.
I'm really surprised this still isn't supported in mainstream DBMSes. The MVCC model in PostgreSQL seems particularly well suited to it.
[1]: https://github.com/ReadyTalk/revori
GRDB.swift
-
Bundling database with iOS app
I'm using GRDB , you can use existing pre-populated sqlite DB file. https://github.com/groue/GRDB.swift/wiki/Performance .
-
How can I quickly parse a huge 45MB JSON file using JsonDecoder
Not quite exactly sure what you mean but if its a .sqlite3 file then you can use it with this easy to use library https://github.com/groue/GRDB.swift
-
Question about Apple's review
The 3rd party library I use GRDB SwiftyUserDefaults Kingfisher SwiftDate Popovers
-
When considering how to store data for something like a cooking recipe application, what are the disadvantages of using CoreData, when compared with other database options?
The other thing is that it could be an overkill for your app if you just need to basically "store an array of 100 objects". Then you could probably consider other solutions like SQLite (with wrappers like GRDB) or plain JSON files.
-
The most amazing project documentation you saw
https://github.com/groue/GRDB.swift#readme https://github.com/groue/GRDB.swift/tree/master/Documentation https://swiftpackageindex.com/groue/grdb.swift/documentation/grdb/
-
Struggles with Logic & CoreData
https://github.com/groue/GRDB.swift/blob/master/Documentation/AssociationsBasics.md might be interesting to look at for how it handles relationships between entities.
-
Database/permanent data storing solution for iOS
I recently used GRDB.
- GRDB-ORM, an ORM for GRDB - Swift SQLite
-
How to decide between JSON and CoreData?
Check the performance comparison page. GRDB comes with a convenient and ready-made support for Swift Codable that performs quite well. When needed, it is possible to write less convenient but optimized record types that add very little overhead to SQLite, and perform really well.
-
Is this an acceptable authentication/account management setup?
Hey all. So I just got done developing an app that does visitation tracking. Basically the user creates an account with email, name, password etc.. the info is then saved to a SQLite database (using GRDB) with a table named "User" and then injected into the next view controller and so on... I plan on allowing the user to store their account in icloud in the future.
What are some alternatives?
rethinkdb_rebirth - The open-source database for the realtime web.
SQLite.swift - A type-safe, Swift-language layer over SQLite3.
cainophile
Realm - Realm is a mobile database: a replacement for Core Data & SQLite
pg-live-select - Live Updating PostgreSQL SELECT statements
FMDB - A Cocoa / Objective-C wrapper around SQLite
PipelineDB - High-performance time-series aggregation for PostgreSQL
SwiftData
flow - 🌊 Continuously synchronize the systems where your data lives, to the systems where you _want_ it to live, with Estuary Flow. 🌊
swift-composable-architecture - A library for building applications in a consistent and understandable way, with composition, testing, and ergonomics in mind.
timely-dataflow - A modular implementation of timely dataflow in Rust
IceCream - Sync Realm Database with CloudKit