Re: [sqlite] compressed sqlite3 database file?

2019-04-11 Thread Peter da Silva
Oy. I've worked on safety-critical systems with hard real-time constraints too. For the most part they didn't *have* file systems or the file systems were basically read-only in production. Sticking a relational database any closer than the SCADA monitoring node would not be a thing that happens,

Re: [sqlite] compressed sqlite3 database file?

2019-04-11 Thread Warren Young
On Apr 11, 2019, at 1:27 PM, James K. Lowden wrote: > > On Wed, 10 Apr 2019 15:14:59 -0600 > Warren Young wrote: > >> If you?re going to buy some more storage, you should put ZFS on it >> then, too. :) > > That's interesting advice for a DBMS mailing list. > > ZFS has built-in

Re: [sqlite] Option to control implicit casting

2019-04-11 Thread James K. Lowden
On Thu, 11 Apr 2019 11:35:04 +1000 John McMahon wrote: > > SELECT x * y & ~1 AS even_numbered_area FROM squares; > > Suggestion: "Don't Do That", use database purely as a storage medium. You yourself don't really believe that! A disk is a storage medium. A file is an undifferntiated stream

Re: [sqlite] compressed sqlite3 database file?

2019-04-11 Thread James K. Lowden
On Wed, 10 Apr 2019 15:14:59 -0600 Warren Young wrote: > On Apr 10, 2019, at 2:12 PM, Keith Medcalf > wrote: > > > > It is far cheaper and much more reliable to just buy some file > > storage space. > > If you?re going to buy some more storage, you should put ZFS on it > then, too. :)

Re: [sqlite] compressed sqlite3 database file?

2019-04-11 Thread Simon Slavin
On 12 Apr 2019, at 1:45am, Warren Young wrote: > ZFS I've used ZFS. ZFS is a great file system for some purposes. Fully-fledged databases isn't one of them. Someone already mentioned the problem of a transaction-based DBMS running on a transaction-based filesystem. I can add the problems