This is like JS Fiddle, but for SQL. Pick from MySQL, Postgres, or SQLite. Then load up some queries, run them, and share with others. Super cool 👍
LGTM, but why?
Mostly because I wanted to dig deeper into node web server code, but also because I haven’t jumped onto the NoSQL bandwagon and think that web APIs are extremely useful. The result is a modest attempt at automating the CRUD boilerplate that every developer hates, while following the specs to make API consumption intuitive. I chose sqlite to keep the database side of things simple, with the intent that the API isn’t serving heavy loads.
How does a database work? What format is data saved in? How are indexes formatted? When and how does a full table scan happen? Join Connor Stack on his journey to answer these questions and more…
I’m building a clone of SQLite from scratch in C in order to understand, and I’m going to document my process as I go.
An alternative command-line client for SQLite. Provides intuitive auto-completion against table names and columns. It’s written in Python, so you can get it with a
pip install litecli
Imagine being able to have many connections to the same database, each one reading a separate branch or commit at the same time. Or even writing to separate branches.
This is a good idea and a testament to the versatility of SQLite. Click through to read how it works and how they’ve managed to 2x the performance of SQLite on Linux and macOS.
This week we talked with Richard Hipp, the creator of SQLite, about its history, where it came from, why it succeeded as a database, how it’s development is sustainably funded, and how it’s the most widely deployed database engine in the world.
Induction is an ambitious new project from Matt Thompson to explore, query, and visualize data from SQL and NoSQL sources including PostgreSQL, MySQL, SQLite, Redis, and MongoDB. While in early alpha, the project shows promise.