nalgeon

32 ms·

1. 481.▲
   Data visualization book with Creative Commons license(antonz.org)

   2 points by nalgeon 6y ago|1 comments
2. 482.▲
   Making a Python Package in 2021(antonz.org)

   2 points by nalgeon 6y ago|0 comments
3. 483.▲
   by nalgeon 6y ago

   Same thing here.
4. 484.▲
   by nalgeon 6y ago

   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.
5. 485.▲
   by nalgeon 6y ago

   I do. Apache Superset, Metabase, Redash - all support SQLite. Other BI tools also do.
6. 486.▲
   SQLite is not a toy database(antonz.org)

   986 points by nalgeon 6y ago|354 comments
7. 487.▲
   by nalgeon 6y ago

   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.
8. 488.▲
   Automate your Python project with Makefile(antonz.org)

   1 points by nalgeon 6y ago|0 comments
9. 489.▲
   by nalgeon 6y ago

   SQLite in WAL mode allows single concurrent writer and unlimited readers. Which is completely fine for a wide range of production use cases.
10. 490.▲
    by nalgeon 6y ago

    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
11. 491.▲
    by nalgeon 6y ago

    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.
12. 492.▲
    by nalgeon 6y ago

    Markus Winand is doing something like that at https://modern-sql.com/ . But it's not nearly as extensive as caniuse.com
13. 493.▲
    by nalgeon 6y ago

    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.
14. 494.▲
    by nalgeon 6y ago

    Yeah, like being able to remove a column! And math functions, can't believe they finally implemented those ツ
15. 495.▲
    by nalgeon 6y ago

    Isn't it done with triggers? SQLite supports them since long ago
16. 496.▲
    What's New in SQLite 3.35(nalgeon.github.io)

    496 points by nalgeon 6y ago|167 comments
17. 497.▲
    Single tool for all subscriptions: RSS, newsletters, Medium, Facebook etc.

    2 points by nalgeon 10y ago|0 comments