| ▲ | gwd 6 days ago | |
> we can't have SQLite because there's only 1 implementation Well now there are [1] at least [2] three [3] implementations, right? [1] sqlite.org | ||
| ▲ | jmull 6 days ago | parent [-] | |
We actually have three distinct one-of-one libraries. There's no standard, so there's no way to really evaluate how standards-compliant they are. It seems like the idea is for the turoso projects to be compatible with sqlite, but it's not clear exactly what means. As a fork, libsql could be kept reasonably backward compatible with recent versions of sqlite by keeping up with merging changes, and avoiding extending sql in conflicting ways. That seems doable if they keep up with the merges, though mainly because they share very large parts of the implementation, so it's not clear it counts as a separate implementation from a web standards perspective. Turso seems like a reimplementation and has a while to go before it achieves some level of compatibility. It probably needs to be much further along before we can really even evaluate it. | ||