3 ms·
You may be underestimating SQLite here. It has grown a LOT of features over the past decade, many of which were directly inspired by PostgreSQL. Features you m
by simonw 5y ago
You may be underestimating SQLite here. It has grown a LOT of features over the past decade, many of which were directly inspired by PostgreSQL.
Features you may have missed:
- CTEs - the WITH statement works great. And recursive CTEs, which can do mandelbrot fractals! https://www.sqlite.org/lang_with.html https://www.sqlite.org/lang_with.html
- Surprisingly good built-in full text search: https://www.sqlite.org/fts5.html https://www.sqlite.org/fts5.html
- Functions for directly querying JSON data in columns: https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html
- Extremely comprehensive geospatial capabilities thanks to the SpatiaLite extension - this has a huge amount of functionality, which I think is better than MySQL though not yet as good as PostGIS: https://www.gaia-gis.it/fossil/libspatialite/index https://www.gaia-gis.it/fossil/libspatialite/index
I'm not saying it's as "good" as PostgreSQL, but I don't thank your argument that PostgreSQL and MySQL implement a substantially larger portion of SQL holds up particularly well.
- capiki 5y agoAs luhn said, it’s more about a standard data format than a db choice. If every client has to figure out what schema a website uses for a recipe, let’s say, then Web 3.0 is still unrealistic. Schema.org exists, but all websites adopting it seems unlikely. That being said, I can maybe see a world in which one company adopts schema.org schemas and the rest have to follow suit to be competitive in that particular domain.
- zozbot234 5y ago> Schema.org exists, but all websites adopting it seems unlikely. Schema.org has the backing of major search engines and other reusers of Web-served content. It's way more likely to be adopted compared to anything else in its general domain.