Announcement

Collapse
No announcement yet.

SQLite 3.21 Picks Up F2FS Atomic Write Support

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLite 3.21 Picks Up F2FS Atomic Write Support

    Phoronix: SQLite 3.21 Picks Up F2FS Atomic Write Support

    SQLite 3.21 is now out as the newest feature release for this widely-used embedded database library...

    http://www.phoronix.com/scan.php?pag...-3.21-Released

  • #2
    Is there anything like SQLite for NoSQL?
    Where you can store things like JSON documents.

    Comment


    • #3
      Originally posted by uid313 View Post
      Is there anything like SQLite for NoSQL?
      Where you can store things like JSON documents.
      https://www.sqlite.org/json1.html

      Comment


      • #4
        Originally posted by uid313 View Post
        Is there anything like SQLite for NoSQL?
        Where you can store things like JSON documents.
        What exactly do you need? If it's just a key value store you may want to look at TokyoCabinet or even BerkeleyDB. Or do you want something like MongoDB, just embedded?

        Comment


        • #5
          Originally posted by bngle View Post
          JSON support in SQL databases tend to suffer from two problems.
          • Non-standard implementation. Not compatible with other RDBMS. Not compliant with the SQL/JSON standard.
          • Writing does not update only the key in the document that was changed but overwrites the entire document.


          Originally posted by nils_ View Post

          What exactly do you need? If it's just a key value store you may want to look at TokyoCabinet or even BerkeleyDB. Or do you want something like MongoDB, just embedded?
          With my limited experience I find key-value stores rather useless for anything else than holding simple configuration, and even not particularly useful for that either.

          I was more thinking of a document store so that I can store JSON objects, something like MongoDB but embedded.

          Comment


          • #6
            Originally posted by uid313 View Post
            I was more thinking of a document store so that I can store JSON objects, something like MongoDB but embedded.
            http://ejdb.org/ might be what you want, or https://unqlite.org/

            Comment


            • #7
              I wonder why nobody implements a DBMS over a embedded database system.

              Originally posted by nils_ View Post

              http://ejdb.org/ might be what you want, or https://unqlite.org/
              Thanks both of those look very interesting.
              EJDB looks particularly interesting.

              Comment


              • #8
                It's nice to see software pick up these sorts of enhancements. Time and filesystem enhancements march forward.

                Even though this particular enhancement is at this stage rather niche. For me it's quite nice since all of my ARM boards are on F2FS and I use sqlite for my custom package manager DB files.

                BTW: F2FS has been working on my Arm boards for years now, and has given me little to no problems. It's also interesting that F2FS's storage strategy seems to be a very nice fit for SMR drives. I'm waiting just a bit more, maybe a year or two before I get serious about maybe using host-managed SMR drives. I have large archived files that are seldom accessed and SMR can potentially bring down cost/TB significantly for that use.

                Comment

                Working...
                X