- https://www.goodreads.com/book/show/1032724.The_Art_of_SQL
- Designing Data-Intensive Applications: review + HN + Reddit + What are must-know concepts for back end development? + https://schiener.io/2022-02-25/designing-data-intensive-applications + https://schiener.io/2022-02-26/understanding-distributed-systems
- https://lethain.com/handbook-relational-db-design-on-data-modeling
- https://www.amazon.com/DBA-Survivor-Become-Rock-Star/dp/1430227877
- beginners
- Advanced SQL and database books and resources
- The DynamoDB Book: Data Modeling with NoSQL and DynamoDB
- https://www.neilwithdata.com/advanced-sql
- https://github.com/bevacqua/reads#databasessearch
- CRDTs will bring us the reallyinteresting next web
- https://driftingin.space/posts/you-might-not-need-a-crdt + https://github.com/jorendorff/talks/blob/master/textarea-distributed/textarea-distributed.md
- https://github.com/localfirstweb/localfirstweb.dev
- https://madebyevan.com/algos
- Streaming Systems. The What, Where, When, and How of Large-Scale Data Processing by Tyler Akidau, Slava Chernyak, and Reuven Lax
- https://github.com/mhadidg/software-architecture-books#streaming-and-messaging
- https://github.com/karlseguin/the-little-mongodb-book
- Curious moon. Learn PostgreSQL the way the pros do | Rob Conery
- https://github.com/iharh/notes/tree/master/db
- The Theory of Relational Databases | David Maier
- http://graysoftinc.com/book-reviews/the-definitive-guide-to-sqlite
- Seven Databases in Seven Weeks | Luc Perkins, Eric Redmond, and Jim Wilson
- https://pragprog.com/titles/bksap1/sql-antipatterns-volume-1
- https://www.reddit.com/r/databasedevelopment/comments/unj8d1/getting_started_with_database_development
- Databases and Data Management by Pragmatic
- https://www.amazon.com/SQL-Data-Scientists-Beginners-Building/dp/1119669367
- https://news.ycombinator.com/item?id=23070491
- https://www.udemy.com/course/database-engines-crash-course
- CMPT 354: Database Systems and Structures (Summer 1998)
- https://www.sqlhabit.com/blog/posts/how-to-detect-recurring-payments-with-sql
- https://blog.bradfieldcs.com/how-to-learn-about-database-systems-40c7432f471d
- Introduction to Databases - Jennifer Widom - Stanford
- https://www.freecodecamp.org/news/watch-a-cornell-university-database-course-for-free
- https://www.freecodecamp.org/news/learn-to-use-the-mysql-database
- https://github.com/AlisdairO/pgexercises
- https://www.freecodecamp.org/news/build-a-crm
- https://github.com/stars/timqian/lists/db-client
- https://sqlime.org + https://github.com/nalgeon/sqlime + https://twitter.com/ohmypy/status/1441389585129377798
- Visualizing missing data in databases
- Version control for databases: save, restore, and archive snapshots of your database from the command line
- https://www.johndcook.com/blog/2019/12/31/sql-join-csv-files
- Build minimum viable admin panels quickly with just SQL
- Analyzing node.js on GitHub with BigQuery
- https://chartio.com/blog/why-we-made-sql-visual-and-how-we-finally-did-it
- https://medium.com/@woj_ciech/leaklooker-gui-discover-browse-and-monitor-database-source-code-leaks-f4b82bbb48fe + https://github.com/woj-ciech/LeakLooker
- https://blog.codepen.io/2018/06/07/need-to-store-some-data
- SQLmap guide + http://www.it-docs.net/ddata/4956.pdf
- The Open Source Airtable Alternative. Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart-spreadsheet + https://news.ycombinator.com/item?id=27303783
- A Node.js powered tool that wraps pgdump and pgrestore then lets you share database dumps using git.
- GUI to interact with databases
- View SQLite file online
- PgTyped automatically generates types and interfaces for your SQL queries by using your running Postgres database as the source of type information
- Convert an Apple Healthkit export zip to a SQLite database
- Ghostferry is a library that enables you to selectively copy data from one mysql instance to another with minimal amount of downtime
- https://shopify.engineering/upgrading-mysql-shopify
- SQL Designer, your online SQL diagramming tool
- https://thomasjfrank.com/notion-databases-the-ultimate-beginners-guide + https://twitter.com/TomFrankly/status/1532771931073744897
- You can feed sqlmap swagger files
- Query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL
- https://haqpl.github.io/Introducing-sqlmap-into-non-HTTP-services + https://github.com/haqpl/shiny-garbanzo
- A tool for exploring Firebase datastores
- https://github.com/zsolt-dev/backup-mysql-to-gcp-storage
- Use SQL to instantly query your cloud services (AWS, Azure, GCP and more)
- If you work with SQL Server, dbatools is a lifesaver
- query engine, which can be used to query any data source or combination of data sources: databases, APIs, raw files (JSON, CSV, etc.), git version control, etc + https://github.com/obi1kenobi/trustfall + https://www.hytradboi.com/2022/how-to-query-almost-everything
- Generate an ER Diagram based on your Prisma schema: https://github.com/keonik/prisma-erd-generator + https://github.com/Skn0tt/prisma-erd
- A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, Google BigQuery, SQLite, TiDB and many more via ODBC + https://getsqlpad.com/en/introduction/#alternatives
- https://turso.tech/blog/5-best-free-sqlite-gui
- Tunneling traffic through MySQL service (or your mysqld is my new SOCKS5): tweet + blog post
- Exploiting misconfigured firebase databases + http://ghostlulz.com/google-exposed-firebase-database
- https://medium.com/@knownsec404team/mysql-client-arbitrary-file-reading-attack-chain-extension-727bb63f578c
- Executing Python inside MSSQL using sp_execute_external_script
- https://github.com/qazbnm456/awesome-security-trivia#sql
- https://dev.to/hacubu/how-to-use-google-sheets-as-a-database-responsibly-3ohk
- https://github.com/cldrn/InsecureProgrammingDB
- https://saligrama.io/blog/post/firebase-insecure-by-default
- https://github.com/securebinary/firebaseExploiter
- https://sqlfordevs.com/uuid-prevent-enumeration-attack
- Algorithms behind Modern Storage Systems.
- CMU Database Group
- SQL Tutorial for Beginners by Ben Awad
- https://www.deconstructconf.com/2018/jumana-bahrainwala-how-to-scale-relational-database-migrations
- RethinkDB | Eric Bell
- https://github.com/mitchellh/advent-2021-sql + https://m.youtube.com/playlist?list=PL4z1WbdlT5GJqdGnuvoqw4dOdB2etJ6sd
- SQL Injection Master Class | Derek Rook + https://gitlab.com/r00k/sql_for_hackers
- Distributed systems for fun and profit | Mikito Takada
- Programming Models for Distributed Computation
- A Distributed Systems Reading List + https://news.ycombinator.com/item?id=25987664 + https://dev.to/nyxtom/resources-for-learning-about-crdt-for-realtime-collaboration-5bkj
- https://jakelazaroff.com/words/an-interactive-intro-to-crdts
- https://github.com/benjamintanweihao/distributed-systems-references
- https://caitiem.com/2017/09/07/getting-started-with-distributed-systems
- Database Internals: A Deep Dive into How Distributed Data Systems Work | Alex Petrov
- Distributed Systems Engineering notes (6.824, Spring 2015)
- CSE138 (Distributed Systems) lectures, Spring 2021 + https://decomposition.al/blog/2020/03/31/twitch-plays-cse138
- Distributed Software Systems: Global-First and Local-First Perspectives
- DriftDB – an open source WebSocket backend for real-time apps + https://m.youtube.com/@driftinginspace9054/videos
- Programming Models for Distributed Computing + https://github.com/heathermiller/dist-prog-book
- https://github.com/riyazwalikar/injection-attacks-nosql-talk
- A Primer on the DynamoDB NoSQL database.
- https://github.com/lrlna/sketchin/blob/master/zines/mongodb101.md
- https://www.bugsnag.com/blog/getting-started-with-mongodb
- https://github.com/learning-zone/mongodb-basics
- https://github.com/dabit3/dynamodb-documentclient-cheat-sheet
- https://www.freecodecamp.org/news/the-apache-cassandra-beginner-tutorial
- https://github.com/riyazwalikar/injection-attacks-nosql-talk
- Postgres is the perfect database.
- http://postgresguide.com
- Postgres Explain Visualizer 2
- Sync Postgres data between databases
- Simplify: Move Code Into Database Functions
- https://daniel-upton.com/articles/introduction-to-cassandra-for-sql-folk
- https://www.2ndquadrant.com/en/blog/postgresql-is-the-worlds-best-database
- https://leontrolski.github.io/nested-sql.html
- https://medium.com/@rbranson/10-things-i-hate-about-postgresql-20dbab8c2791
- https://thedataguy.in/internals-of-google-cloud-spanner
- Some SQL Tricks of an Application DBA
- https://knowledgepill.it/posts/postgresql-basics-guide
- Self-taught webdev with lots of free time. What should I learn?
- Postgres Observability
- https://tomcam.github.io/postgres + https://news.ycombinator.com/item?id=25113440
- https://postgresqlco.nf/en/doc/param + https://news.ycombinator.com/item?id=25024224
- But nobody writes production applications with SQLite, right? https://litestream.io/blog/why-i-built-litestream + https://twitter.com/benbjohnson/status/1359906563285254149 + https://twitter.com/benbjohnson/status/1359944904588353537
- https://github.com/ABZ-Aaron/CheatSheets
- https://www.jakeworth.com/how-to-read-postgres-docs
- https://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design
- Query the StackOverflow data to get an insight into what people are asking about
- https://github.com/CyC2018/CS-Notes/blob/master/notes/SQL%20%E7%BB%83%E4%B9%A0.md
- SapphireDb. An alternative to Firebase
- A lightweight cloud firestore library for the browser.
- You've got 100k requests/minute coming in, that need to return immediately, and you need to put a record in a database for every one.
- https://fly.io/blog/sqlite-internals-rollback-journal
- Turning SQLite into a distributed database
- https://twitter.com/captbaritone/status/1552313020067594249
- https://tantaman.com/2022-08-23-why-sqlite-why-now.html
- https://twitter.com/reneeshah123/status/1562843950309814272
- https://twitter.com/gvwilson/status/1562595621663817728
- https://twitter.com/agarcia_me/status/1539635620598796288
- when does SQLite suck?
- https://twitter.com/agarcia_me/status/1563231553299197952
- Simple graph database in SQLite, inspired by "SQLite as a document database"
- https://github.com/tantaman/conflict-free-sqlite
- https://twitter.com/captbaritone/status/1560053602487377920
- https://dev.to/lefebvre/sqlite-is-not-a-server-56il
- SQLite implementation over Wasm will replace Web SQL
- Stranger Strings
- Using SQLite as a data source: a framework and an example
- offline-first note-taking app on top SQLite + https://github.com/quolpr/harika
- https://kentcdodds.com/blog/i-migrated-from-a-postgres-cluster-to-distributed-sqlite-with-litefs
- https://blog.chiselstrike.com/sqlite-based-databases-on-the-postgres-protocol-yes-we-can-358e61171d65
- https://fly.io/blog/sqlite-virtual-machine
- https://corecursive.com/066-sqlite-with-richard-hipp + https://news.ycombinator.com/item?id=27718701
- https://github.com/dogsheep/apple-notes-to-sqlite
- https://github.com/almandin/ntdsdotsqlite
- proposal: should node expose a persistent KV API
- SQLite database manager written in C++, with use of Qt framework
- https://www.arangodb.com/learn/first-day/udemy
- https://github.com/neo4j-contrib/rabbithole
- A Graph-Based Firebase
- Oxigraph is a graph database implementing the SPARQL standard
- What is easy to do with Redis?
- https://philbooth.me/blog/four-ways-to-shoot-yourself-in-the-foot-with-redis
- Carrier Cache and Carrier DB
- Need a lightweight DB for a toy node project I'm working on. I always reach for DiskDB
- Simple key-value storage with support for multiple backends
- https://antimatter15.com/2015/12/recovering-deleted-data-from-leveldb
- Anyone tried Gun.js? Thoughts?
- EdgeDB is looking clean.
- An implementation of the exact same app in Firestore, AWS Datastore, PouchDB, RxDB and WatermelonDB
- Database of Databases + https://news.ycombinator.com/item?id=24494403
- What are some examples of good database schema designs?
- https://muldoon.cloud/programming/2020/04/17/programming-rules-thumb.html#rule-11-which-database-technology-to-choose
- https://metaduck.com/the-history-of-databases-a-summary
- https://github.com/pingcap/awesome-database-learning
- https://github.com/madd86/awesome-system-design
- https://erikbern.com/2018/08/30/i-dont-want-to-learn-your-garbage-query-language.html
- https://rawrmaan.com/why-parse-failed
- Database As a Service
- SQL, NoSQL, and Scale - How DynamoDB scales where relational databases don't: tweet + article
- https://ovid.github.io/articles/database-design-standards.html
- https://joshduff.com/2016-07-writing-sql.md
- Things I wished more developers knew about databases.
- Using SQL to find my best photo of a pelican according to Apple Photos
- https://gbl08ma.com/time-for-a-wtf-mysql-moment
- https://blog.jooq.org/2019/11/13/stop-mapping-stuff-in-your-middleware-use-sqls-xml-or-json-operators-instead + https://twitter.com/lukaseder/status/1331897735361028097
- https://materialize.com/kafka-is-not-a-database + https://news.ycombinator.com/item?id=25346851
- https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss + https://news.ycombinator.com/item?id=25870482
- Do you prefer SQL or NoSQL databases?
- https://romanorac.github.io/data/analytics/2019/11/11/5-mistakes-sql-queries.html
- https://twitter.com/tlhunter/status/1459624433488850945
- https://github.com/sujeet-agrahari/awesome-database-design
- Against unnecessary databases
- https://medium.com/@tjukanov/finding-the-most-innovative-square-kilometer-in-europe-with-spatial-sql-46b0fc4bde62
- Parallel Self-Tuning Spectral Clustering on Apache Spark | Armand Grillet
- https://github.com/mgp/book-notes/blob/master/sqlalchemy.markdown
- A More Human Approach To Databases
- https://shekhargulati.com/category/code-reading
- https://github.com/harpribot/awesome-information-retrieval
- https://www.singlestore.com/blog/engineers-guide-building-database-for-data-intensive-applications
- https://github.com/binhnguyennus/awesome-scalability
- https://github.com/huachaohuang/awesome-dbdev
- https://www.crunchydata.com/blog/learn-postgres-at-the-playground
- The past, present, and future of Postgres, and the Postgres Playground
- Advent of Code 2021
- https://www.freecodecamp.org/news/learn-supabase-open-source-firebase-alternative + https://github.com/guillaumeduhan/supabase-vue3