#database
14 notes and posts, 45 links.
Notes and posts
LLMs in Data Management
[@10.14778/3611479.3611527]; PDF We argue that the disruptive influence that LLMs will have on data management will come from two angles. (1) A number of hard database problems, namely, entity resolution, schema…
Data Apps
Data applications (usually), web application frameworks that make it easy to publish data as dynamic reports that have an element of interactivity to them that is not possible in static reports, they are often…
scratchdb
ScratchDB Via HN announcement: ScratchDB provides two endpoints [1]: one to insert data and another to query. When you send any JSON, it automatically creates tables and columns based on the structure [2]. Because table…
foundationdb
Homepage: FoundationDB FoundationDB is an open source multi-modal distributed k-v store database developed by Apple. It backs Snowflake and also many iCloud services. It is often thought of as a toolkit to build your…
Clickhouse
Introduction Home page -- Fast Open-Source OLAP DBMS - ClickHouse clickhouse-local is an easy-to-use version of ClickHouse that is ideal for developers who need to perform fast processing on local and remote files using…
Text search engines
PostgreSQL Postgres as a search engine Smaller alternatives to Elasticsearch without all the features valeriansaliou/sonic: 🦔 Fast, lightweight & schema-less search backend. An alternative to Elasticsearch that runs on…
Duckdb
davidgasquez/awesome-duckdb: 🦆 A curated list of awesome DuckDB resources Papers Notes on the SQLite DuckDB paper Articles Why DuckDB is my first choice for data processing; Mar 2025. Build a poor man’s data lake from…
Vector Databases
What is a Vector Database? from the pinecone.io team. Common Use cases for vector search: Semantic Search Similarity search for images, audio, video, JSON, and other forms of unstructured data Ranking and Recommendation…
Databases
Meta dbdb.io - Database of Databases CQL - categorial databases. Open-source CQL and its integrated development environment (IDE) performs data-related tasks — such as querying, combining, migrating, and evolving…
Database Systems
Learning CMU 15-445/645 :: Intro to Database Systems (Fall 2021) Database Fundamentals This is when I decided to read the excellent books Database Internals by Alex Petrov and Designing Data-Intensive Applications by…
PostgreSQL
Why PostgreSQL PostgreSQL is Enough; and Just Use Postgres for Everything. Just use Postgres Quickstart Pedram Navid | A Fast, Sample Postgres Database with Docker Learning PostgreSQL DBA Roadmap: Learn to become a…
datasette
Datasette is a tool for exploring and publishing data. Uses sqlite for storing data and is written in python and exposes the db over a web interface. support adhoc querying (made posible by mounting the database file in…
SQL
SQL Words ( via ) On SQL Modern Data Practice and the SQL Tradition | Florents Tselai 12 Common Mistakes and Missed Optimization Opportunities in SQL | Haki Benita I Don't Need Your Query Language Your Database Skills…
Sqlite
I wrote an article about SQLite for DeveloperIQ magazine published in Jan 2005 -- Move Over MySQL, SQLite is here!! --- Query Parquet files in SQLite | Colin Dellow Importing csv into sqlite: see this page for extended…
Links Open in the Archive
How FoundationDB works and why it works | Lu’s blog
How FoundationDB works and why it works (2021) | Hacker News
The BugBash Podcast Episode 1 -- FoundationDB: from idea to Apple acquisition - YouTube
via
djrobstep/migra: Like diff but for PostgreSQL schemas
migra: Like diff but for Postgres schemas compare schemas autogenerate migration scripts autosync your development database from your application models make…
The DuckDB Local UI
can have multiple databases including in memory database attached. Can explore the databases using Table summary, the notebooks are useful in organizing work…
QuestDB | Peak time-series performance database
Can be combined with Perspective for some cool timeseries data visualization.
The Cell Programming Language
an interesting embeddable programming language to complement and integrate with your primary language like C++, Java and C#. The authors claim it is useful in…
looker-open-source/malloy: Malloy is an experimental language for describing data relationships and transformations.
🗄️ Databases
-
Concurrency Control and Recovery in Database Systems - Microsoft Research
TeachLogic Home
link to Logic and Database queries paper.
Liquibase | Database Refactoring | Faq
Tracking, managing and applying database changes.
Berkeley Database Paper Archive
Database development mistakes made by application developers - Stack Overflow
c-phrase - Project Hosting on Google Code
C-Phrase is a web-based natural language front end to relational databases developed by Michael Minock and his students at Umeå University, Sweden. C-Phrase…
Top 10 Performance Problems taken from Zappos, Monster, Thomson and Co Application Performance, Scalability and Architecture – The dynaTrace Blog
RT @zzzeek: Top 10 performance issues from big sites: . no. 1: no fine grained queries, identity map, or eagerloads ...
OpenTSDB - A Distributed, Scalable Monitoring System
Getting Started with HTML5 Local Databases « Dark Crimson Blog
WTF is a SuperColumn? An Intro to the Cassandra Data Model — Arin Sarkissian
Dennis Forbes on Software and Technology - Getting Real about NoSQL and the SQL-Isn't-Scalable Lie
Why I think Mongo is to Databases what Rails was to Frameworks // RailsTips by John Nunemaker
MySQL Tips
Riak - A Decentralized Database
MySQL partitions tutorial
Highly Scalable Data Stores
buzhug, a pure-Python database engine
using a Pythonic, no-SQL syntax
"Relational Databases", Comm. of the ACM 35,4 (April 1992), 16,18.
Extracting META informations from PostgreSQL (INFORMATION_SCHEMA) - Lorenzo Alberton
Extracting META informations from PostgreSQL using INFORMATIONSCHEMA and table catalogs
Proximity Software
Spyced: ORM design part 2: Jonathan's Python Blog
- More links