3 ms·
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
by gigatexal 10y 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 10y agoI 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 10y agoyeah that site is really good for a lot of things. Windowing functions help you write less procedural SQL -- I'm a huge fan.
- groue 10y 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 10y agoHmm, i had no idea it was that powerful/feature rich.