3 ms·

It's a good question, and I don't think answered sufficiently in the recent sqlite hype. In my opinion if you have an easy way to run postgres,MySQL,... - just

It's a good question, and I don't think answered sufficiently in the recent sqlite hype. In my opinion if you have an easy way to run postgres,MySQL,... - just run that. There's usually a lot of quirks in the details of DB usage (even when it doesn't immediately seem like it - got bitten by it a few times). Features not supported, different semantics, ... IMO every project has an "experimental stuff" budget and if you go over it it's too broken to recover, and for most projects there's just not that much to win by spending them on a new database thing

skeeter2020 1y ago
>> the recent sqlite hype. This is an interesting take; why do you see recent hype around the most boring and stone-age of technologies, SQLite?
- sauercrowd 1y ago
  The rails creator dhh has been hyping it up a lot in the first 6 month of this year, and quite a few followed of the "Dev influencers" scene. Fly's litestream came out around that time, and there's been more sqlite in the cloud companies/discussions, in particular with the AI agent use-case. Not super sure who followed who but there was all of a sudden a lot of excitement
  - simonw 1y ago
    Litestream's first release was February 2021: https://news.ycombinator.com/item?id=26103776 https://news.ycombinator.com/item?id=26103776 SQLite's "buzz" isn't new, type "sqlite" into my https://tools.simonwillison.net/hacker-news-histogram https://tools.simonwillison.net/hacker-news-histogram tool and you'll see interest (on HN at least) has been pretty stable since 2021.
    - nirvdrum 1y ago
      Maybe it's a local bump, but it sure seems like SQLite has become a fair more popular topic in the Rails world. I wouldn't expect to find it in a HN search tool. SQLite has gone from the little database you might use to boostrap or simplify local development to something products are shipping with in production. Functionality like solid_cable, solid_cache, and solid_queue allow SQLite to be used in more areas of Rails applications and is pitched as a way to simplify the stack. While I don't have stats about every conference talk for the last decade, my experience has been that SQLite has been featured more in Rails conference talks. There's a new book titled "SQLite on Rails: The Workbook" that I don't think would have had an audience five years ago. And I've noticed more blog posts and more discussion in Rails-related discussion platforms. Moreover, I expect we'll see SQLite gain even more in popularity as it simplifies multi-agent development with multiple git worktrees.
    - sauercrowd 1y ago
      My bad, I remember vaguely that fly io had a "litefs released" post but I seem to have confused timelines
      - simonw 1y ago
        Yeah LiteFS was more recent - September 2022, https://fly.io/blog/introducing-litefs/ https://fly.io/blog/introducing-litefs/ - and the Cloud hosted version was July 2023 https://fly.io/blog/litefs-cloud/ https://fly.io/blog/litefs-cloud/
        sauercrowd 1y ago
        Oh right the cloud version is what I remember - thanks for clarifying Bit more stretched out than I thought it had been

skeeter2020 1y ago

>> the recent sqlite hype. This is an interesting take; why do you see recent hype around the most boring and stone-age of technologies, SQLite?

sauercrowd 1y ago
The rails creator dhh has been hyping it up a lot in the first 6 month of this year, and quite a few followed of the "Dev influencers" scene. Fly's litestream came out around that time, and there's been more sqlite in the cloud companies/discussions, in particular with the AI agent use-case. Not super sure who followed who but there was all of a sudden a lot of excitement
- simonw 1y ago
  Litestream's first release was February 2021: https://news.ycombinator.com/item?id=26103776 https://news.ycombinator.com/item?id=26103776 SQLite's "buzz" isn't new, type "sqlite" into my https://tools.simonwillison.net/hacker-news-histogram https://tools.simonwillison.net/hacker-news-histogram tool and you'll see interest (on HN at least) has been pretty stable since 2021.
  - nirvdrum 1y ago
    Maybe it's a local bump, but it sure seems like SQLite has become a fair more popular topic in the Rails world. I wouldn't expect to find it in a HN search tool. SQLite has gone from the little database you might use to boostrap or simplify local development to something products are shipping with in production. Functionality like solid_cable, solid_cache, and solid_queue allow SQLite to be used in more areas of Rails applications and is pitched as a way to simplify the stack. While I don't have stats about every conference talk for the last decade, my experience has been that SQLite has been featured more in Rails conference talks. There's a new book titled "SQLite on Rails: The Workbook" that I don't think would have had an audience five years ago. And I've noticed more blog posts and more discussion in Rails-related discussion platforms. Moreover, I expect we'll see SQLite gain even more in popularity as it simplifies multi-agent development with multiple git worktrees.
  - sauercrowd 1y ago
    My bad, I remember vaguely that fly io had a "litefs released" post but I seem to have confused timelines
    - simonw 1y ago
      Yeah LiteFS was more recent - September 2022, https://fly.io/blog/introducing-litefs/ https://fly.io/blog/introducing-litefs/ - and the Cloud hosted version was July 2023 https://fly.io/blog/litefs-cloud/ https://fly.io/blog/litefs-cloud/
      - sauercrowd 1y ago
        Oh right the cloud version is what I remember - thanks for clarifying Bit more stretched out than I thought it had been