#database

Ordinary SQLite files, one sharded database—parallel writes, PostgreSQL, HTTP, Rust, Python, and shard-safe IDs.

N+1 Queries Are Not A Problem With SQLite SQLite is not client/server, however. The SQLite database runs in the same process address space as the application. Queries do not involve message round-trips, only a function call. The latency of a single SQL query is far less in SQLite. Hence, using a large number of queries with SQLite is not the problem.

The json_extract(X,P1,P2,...) extracts and returns one or more values from the well-formed JSON at X.

Dogsheep is a collection of tools for personal analytics using SQLite and Datasette.

Dogsheep is a collection of tools for personal analytics using SQLite and Datasette.

This 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.

"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"

"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"

You 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.

You 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.

A Minimalistic Wrapper for IndexedDB

A Minimalistic Wrapper for IndexedDB

The fact that PouchDB works at all is a tiny miracle.

Using databases for the primary storage of content on your personal site is considered by some in the community to be an antipattern.

I’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.

I’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.

Enjoy an intuitive query language, automatically parallelized queries, and simple administration.

Enjoy an intuitive query language, automatically parallelized queries, and simple administration.

Obvious 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:

From 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.

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.

"In this guest post Jake Luciani (@tjake) introduces Lucandra, a Cassandra-based backend for Lucene."

"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."

@stlhood Did you just tell me to go eff myself?

"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. "

Well... I guess 150MB is actually "small-footprint" for Oracle.

"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."

"Here's a brief outline of the four production-ready XPath functions which represent the most complete XML support of any open source RDBMS."

Nifty new widget from the creator of Gadfly