HNHacker News
TopNewBestAskShowJobs

nalgeon

6,898 karma · joined December 12, 2016

antonz.org
submissionscomments
nalgeon··on SQLite is not a toy database
Same thing here.
nalgeon··on SQLite is not a toy database
I think that the absence of 'high availability' is not an issue for small websites or web apps. Transactions are ACID, concurrent readers are fully supported. Backups and administrative tasks are super-easy.
nalgeon··on SQLite is not a toy database
I do. Apache Superset, Metabase, Redash - all support SQLite. Other BI tools also do.
nalgeon··on How to create a 1M record table with a single query
WITH RECURSIVE is supported in MariaDB 10.2+, MySQL 8.0+, PostgreSQL 8.4+ and SQLite 3.8+. Oracle 11.2+ and SQL Server 2005 support recursive queries, but without the RECURSIVE keyword.
nalgeon··on What's New in SQLite 3.35
SQLite in WAL mode allows single concurrent writer and unlimited readers. Which is completely fine for a wide range of production use cases.
nalgeon··on What's New in SQLite 3.35
SQLite has ISO-8601 compatible date functions, isn't that enough?

  sqlite> select datetime('now', '-90 days');
  2020-12-12 21:44:22
https://sqlite.org/lang_datefunc.html
nalgeon··on What's New in SQLite 3.35
datasette is a wonderful piece of software! Simon Willison has created a great tooling around SQLite. Can't imagine how much time and energy he has invested in these projects.
nalgeon··on What's New in SQLite 3.35
Markus Winand is doing something like that at https://modern-sql.com/. But it's not nearly as extensive as caniuse.com
nalgeon··on What's New in SQLite 3.35
SQLite is really great at crunching data! I definitely prefer it over pandas in most cases, as SQL is naturally fit to joins, aggregates etc. Also SQLite works natively with JSON, which is a huge time saver.
nalgeon··on What's New in SQLite 3.35
Yeah, like being able to remove a column! And math functions, can't believe they finally implemented those ツ
nalgeon··on What's New in SQLite 3.35
Isn't it done with triggers? SQLite supports them since long ago
← PreviousPage 4 of 4