5 ms·

Does SQLite still not support remote connections? Without that, it's hard for me to take it seriously for most RDBMS use cases.

ok_dad 4y ago
SQLite is an embedded database so you wouldn’t really want that. Postgres is fine for database servers, SQLite is for program-embedded local databases.
- Gigachad 4y ago
  I don't think anyone has questioned sqlite for local databases. But there is a lot of talk around using sqlite for web app databases where it may work, but seems clearly inferior to any of the alternatives.
  - Aperocky 4y ago
    Depend on what size the webapp is. sqlite.com seems a pretty good cut off traffic volume, I would guess between 95-99% of all web apps are probably consistently getting less traffic than sqlite.com
    - chrsig 4y ago
      is sqlite.com a dynamic site? it seems like it's static html
      - Aperocky 4y ago
        supposedly they are powered by sqlite, so it has to be read somehow. Though a cache may have been what most of the traffic is hitting.
      - rawoke083600 4y ago
        I read somewhere on their page, each page is done with about 200 queries.
      - SQLite 4y ago
        There is a lot of static content on https://sqlite.org/ https://sqlite.org/ but also a lot of SQLite-backed dynamic content. I just checked the logs. Over the past 5 days, 12.03% of non-robot HTTP requests were against dynamically generated pages. Most of the dynamic content is generated by the version control system, Fossil (https://fossil-scm.org/ https://fossil-scm.org/). For example: https://sqlite.org/src/timeline https://sqlite.org/src/timeline or https://sqlite.org/forum/forum https://sqlite.org/forum/forum Fossil is hosted on the same machine as SQLite. Fossil is self-hosting and the Fossil website is 100% dynamically generated. Every HTTP request against https://fossil-scm.org/ https://fossil-scm.org/ does about 200 SQLite queries (give or take - depending on the page).
howinteresting 4y ago
SQLite is an embedded database, so there's no "still". It's a completely different kind of system from a traditional networked database. It's like asking if Python still doesn't support running without a garbage collector.
bitwize 4y ago
SQLite is targeting a different application space than PostgreSQL, MySQL, Oracle Database, or SQL Server. It's intended to be embedded in applications to provide easy, rapid access to structured data. Both iOS and Android, for instance, embed SQLite and apps use it for storing things like text messages and contacts. Even Microsoft UWP embeds SQLite and provides an API to access it from .NET applications (which is weird because it's more on-brand for Microsoft to embed, say, the Jet database engine from Access). It's a serious database for anything that doesn't require concurrent multiuser access.
chasil 4y ago
It does support remote connections, but at the NFS or SMB level.
- vonseel 4y ago
  Isn't SMB not recommended because it can lead to corrupted database? Or is there a setting I disabled somewhere in my smbd.conf that I should re-enable (oplocks maybe?? )?
  - chasil 4y ago
    There is a draft document on networking. Since only a single process may write to a database, it would be best if that process were local. NFSv4 has built-in file locking, which is likely the most preferable protocol. SMBv2 is a massive rewrite of that protocol, and I expect any file locking problems would be addressed (especially as Microsoft sponsored SQLite changes specifically for Windows 10). Remote readers in explicit read-only mode likely won't hurt, but there is a deeper discussion below. https://www.sqlite.org/draft/useovernet.html https://www.sqlite.org/draft/useovernet.html

ok_dad 4y ago

SQLite is an embedded database so you wouldn’t really want that. Postgres is fine for database servers, SQLite is for program-embedded local databases.

Gigachad 4y ago
I don't think anyone has questioned sqlite for local databases. But there is a lot of talk around using sqlite for web app databases where it may work, but seems clearly inferior to any of the alternatives.
- Aperocky 4y ago
  Depend on what size the webapp is. sqlite.com seems a pretty good cut off traffic volume, I would guess between 95-99% of all web apps are probably consistently getting less traffic than sqlite.com
  - chrsig 4y ago
    is sqlite.com a dynamic site? it seems like it's static html
    - Aperocky 4y ago
      supposedly they are powered by sqlite, so it has to be read somehow. Though a cache may have been what most of the traffic is hitting.
    - rawoke083600 4y ago
      I read somewhere on their page, each page is done with about 200 queries.
    - SQLite 4y ago
      There is a lot of static content on https://sqlite.org/ https://sqlite.org/ but also a lot of SQLite-backed dynamic content. I just checked the logs. Over the past 5 days, 12.03% of non-robot HTTP requests were against dynamically generated pages. Most of the dynamic content is generated by the version control system, Fossil (https://fossil-scm.org/ https://fossil-scm.org/). For example: https://sqlite.org/src/timeline https://sqlite.org/src/timeline or https://sqlite.org/forum/forum https://sqlite.org/forum/forum Fossil is hosted on the same machine as SQLite. Fossil is self-hosting and the Fossil website is 100% dynamically generated. Every HTTP request against https://fossil-scm.org/ https://fossil-scm.org/ does about 200 SQLite queries (give or take - depending on the page).

howinteresting 4y ago

SQLite is an embedded database, so there's no "still". It's a completely different kind of system from a traditional networked database. It's like asking if Python still doesn't support running without a garbage collector.

bitwize 4y ago

SQLite is targeting a different application space than PostgreSQL, MySQL, Oracle Database, or SQL Server. It's intended to be embedded in applications to provide easy, rapid access to structured data. Both iOS and Android, for instance, embed SQLite and apps use it for storing things like text messages and contacts. Even Microsoft UWP embeds SQLite and provides an API to access it from .NET applications (which is weird because it's more on-brand for Microsoft to embed, say, the Jet database engine from Access). It's a serious database for anything that doesn't require concurrent multiuser access.

chasil 4y ago

It does support remote connections, but at the NFS or SMB level.

vonseel 4y ago
Isn't SMB not recommended because it can lead to corrupted database? Or is there a setting I disabled somewhere in my smbd.conf that I should re-enable (oplocks maybe?? )?
- chasil 4y ago
  There is a draft document on networking. Since only a single process may write to a database, it would be best if that process were local. NFSv4 has built-in file locking, which is likely the most preferable protocol. SMBv2 is a massive rewrite of that protocol, and I expect any file locking problems would be addressed (especially as Microsoft sponsored SQLite changes specifically for Windows 10). Remote readers in explicit read-only mode likely won't hurt, but there is a deeper discussion below. https://www.sqlite.org/draft/useovernet.html https://www.sqlite.org/draft/useovernet.html