NotesThis makes it possible to insert JSON straight into SQLite and then have it extract data and index them, i.e. you can treat SQLite as a document database. This has been possible with PostgreSQL and obviously is what something like Elastic provides but having it available in an embedded database is very nice for lightweight stuff.FeedUnfurl
Notes"so I implemented a virtual file system that fetches chunks of the database with HTTP Range requests when SQLite tries to read from the filesystem"FeedUnfurl
NotesYou can actually use a relational or a NoSQL database, or an in-memory data structure, or something like Amazon S3. This is made possible by the pluggable backends provided by the libgit2 library.FeedUnfurl
NotesI’m not planning on stopping doing these any time soon, as I need them for my own porpoises, but I thought it might be worth having a few instructions out there, so people can run their own conversions of the EVE SDE. Just in case I get hit by a bus, or mauled by crazed Cetaceans.FeedEmbedUnfurl
NotesObvious to Damien, but not at all obvious to the rest of us: it's fairly simple to make a view that includes both the content of the blog post document, and the content of all the comments associated with that post. The way you do that is by using complex keys. Until now we've been using simple string values for the view keys, but in fact they can be arbitrary JSON values, so let's make some use of that:Unfurl
NotesFrom CTO of 10gen
First, I tried to find any client of ours with a track record like this and have been unsuccessful. I personally have looked at every single customer case that’s every come in (there are about 1600 of them) and cannot match this story to any of them. I am confused as to the origin here, so answers cannot be complete in some cases.Unfurl
Notes I've kept quiet for awhile for various political reasons, but I now feel a kind of social responsibility to deter people from banking their business on MongoDB.Unfurl
Notes"Shown below is a (single query) SQL-generated pie chart. I will walk through the steps towards making this happen, and conclude with what, I hope you’ll agree, are real-world, useful usage samples."FeedEmbedUnfurl
Notes"Spock Proxy supports range-based horizontal paritioning of a large MySQL database. The proxy intercepts SQL queries from the client, sends queries to the correct databases based on how the database is partitioned, then aggregates the results from each database and returns them to the client as a regular MySQL result set. "Unfurl
Notes"MySQL is just not built for large tag-systems. It just doesn't scale. It does scale up to 1 Million items but delicious does have far more posts."Unfurl
Notes"Here's a brief outline of the four production-ready XPath functions which represent the most complete XML support of any open source RDBMS."Unfurl