4 ms·

Unexpected SQLite with Swift

• gigatexal 9y ago
  I'll have to give it another look but the killer missing feature for me is windowing functions. They don't exist in SQLite when I looked at it last (within the last 6 months or so). The callbacks on datachange are nice. They sound similar to change data capture in SQLServer.
  • groue 9y ago
    I didn't know about windowing function. This page looks like a nice description: https://community.modeanalytics.com/sql/tutorial/sql-window-functions/ https://community.modeanalytics.com/sql/tutorial/sql-window-...
    • gigatexal 9y ago
      yeah that site is really good for a lot of things. Windowing functions help you write less procedural SQL -- I'm a huge fan.
  • groue 9y ago
    > They sound similar to change data capture in SQLServer. Yes. There is a difference, though: SQLite is embedded, and there is zero latency between an application and its database. This means that change notifications can be emitted synchronously right after a committed transaction, allowing the application to process the change before any other change could be performed. This makes it much easier to get a very robust solution for a whole class of database synchronization problems.
    • gigatexal 9y ago
      Hmm, i had no idea it was that powerful/feature rich.