Pinboard (keithly)
https://pinboard.in/u:keithly/public/
recent bookmarks from keithlyYour Database Skills Are Not 'Good to Have'2024-04-03T16:51:31+00:00
https://renegadeotter.com/2023/11/12/your-database-skills-are-not-good-to-have.html
keithlyprogramming sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:6562b4ddd0a7/Using DuckDB-WASM for in-browser Data Engineering2024-03-02T13:51:07+00:00
https://tobilg.com/using-duckdb-wasm-for-in-browser-data-engineering
keithlysql programming visualizationhttps://pinboard.in/u:keithly/b:13693a058c8d/SQL Polyglot2023-12-14T15:08:20+00:00
https://codapi.org/sql/
keithlyprogramming sql databasehttps://pinboard.in/u:keithly/b:62424b19491b/Soft Deletion Probably Isn't Worth It2023-05-12T03:16:03+00:00
https://brandur.org/soft-deletion
keithlyprogramming database sqlhttps://pinboard.in/u:keithly/b:e07334bf944a/Lost at SQL - SQL learning game2023-04-27T19:57:19+00:00
https://lost-at-sql.therobinlord.com/
keithlygames sql learning programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:3d9f6f6e16f9/ULIDs and Primary Keys | Dave Allie2023-01-02T02:28:06+00:00
https://blog.daveallie.com/ulid-primary-keys
keithlydatabase postgres ULID programming uuid sqlhttps://pinboard.in/u:keithly/b:d3040e0d0b2f/Postgres Playground | Crunchy Data2022-12-19T21:36:57+00:00
https://www.crunchydata.com/developers/playground
keithlydatabase postgres programming sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:0e33d4bf2c60/Postgres Tips | Crunchy Data2022-12-19T20:58:28+00:00
https://www.crunchydata.com/postgres-tips
keithlydatabase postgres programming sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:4c1bdeca3b89/SQLforDevs.com - Next-Level Database Techniques for Developers Ebook2022-12-06T19:30:19+00:00
https://sqlfordevs.com/ebook
keithlydatabase sql books ebookhttps://pinboard.in/u:keithly/b:7c473ad78c9b/Glue code to quickly copy data from one Postgres table to another2022-09-19T02:04:46+00:00
https://simonwillison.net/2022/Apr/19/glue-code-to-quickly-copy-data-from-one-postgres-table-to-anothe/
keithlypython programming postgres sqlhttps://pinboard.in/u:keithly/b:2533dd321e04/SQLModel2022-09-19T00:21:51+00:00
https://simonwillison.net/2021/Aug/24/sqlmodel/
keithlysql python programminghttps://pinboard.in/u:keithly/b:0ebf39fcc790/Learn Postgres at the Playground2022-08-18T01:19:21+00:00
https://www.crunchydata.com/blog/learn-postgres-at-the-playground
keithlypostgres sql programminghttps://pinboard.in/u:keithly/b:8a228e06e8c9/You Should Use This to Visualize SQL Joins Instead of Venn Diagrams | by Andreas Martinson | Towards Data Science2022-08-06T19:13:42+00:00
https://towardsdatascience.com/you-should-use-this-to-visualize-sql-joins-instead-of-venn-diagrams-ede15f9583fc
keithlysql programming visualizationhttps://pinboard.in/u:keithly/b:47040e9df932/sqlite-utils: a nice way to import data into SQLite for analysis2022-05-28T19:40:41+00:00
https://jvns.ca/blog/2022/05/12/sqlite-utils--a-nice-way-to-import-data-into-sqlite/
keithlysqlite sql programminghttps://pinboard.in/u:keithly/b:9e09c8086d80/Identity Crisis: Sequence v. UUID as Primary Key — brandur.org2022-05-28T19:39:39+00:00
https://brandur.org/nanoglyphs/026-ids
keithlydatabase programming sqlhttps://pinboard.in/u:keithly/b:aa2bb7c2020c/Litestream - Streaming SQLite Replication2022-05-18T16:04:03+00:00
https://litestream.io/
keithlysqlite opensource devops database sql programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:aa2d0a17674b/I'm all-in on server-side SQLite | Hacker News2022-05-10T18:29:34+00:00
https://news.ycombinator.com/item?id=31318708
keithlysqlite sql database programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:cda6bea565a1/Changing Tires at 100mph: A Guide to Zero Downtime Migrations | Kiran Rao2022-05-08T21:03:29+00:00
https://kiranrao.ca/2022/05/04/zero-downtime-migrations.html
keithlydevops sql database migrationshttps://pinboard.in/u:keithly/b:45f16ad8ac31/Wesley Aptekar-Cassels | Consider SQLite2022-04-27T18:39:36+00:00
https://blog.wesleyac.com/posts/consider-sqlite
keithlydatabase sqlite sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:3a4f4e07029f/Open Source SQL Parsers2022-04-24T22:24:29+00:00
https://tokern.io/blog/open-source-sql-parsers/
keithlysql programminghttps://pinboard.in/u:keithly/b:286f92a916d8/Steampipe | select * from cloud;2022-03-04T22:53:57+00:00
https://steampipe.io/
keithlysql opensource aws tools programming devopshttps://pinboard.in/u:keithly/b:9cdb9ea20e9e/Against SQL2021-07-13T19:26:04+00:00
https://scattered-thoughts.net/writing/against-sql
keithlysql programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:257b61b086b9/Practical SQL for Data Analysis | Haki Benita2021-05-04T15:11:01+00:00
https://hakibenita.com/sql-for-data-analysis
keithlypython sql pandashttps://pinboard.in/https://pinboard.in/u:keithly/b:5125e91b558b/SQLite the only database you will ever need in most cases2021-04-19T14:46:12+00:00
https://unixsheikh.com/articles/sqlite-the-only-database-you-will-ever-need-in-most-cases.html
keithlysql database programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:dfa720d2871e/The SQL Murder Mystery2019-12-17T22:58:45+00:00
https://mystery.knightlab.com/
keithlysql learning programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:78e5b8f24a10/SQL is No Excuse to Avoid DevOps - ACM Queue2019-01-12T18:15:58+00:00
https://queue.acm.org/detail.cfm?id=3300018
keithlydatabase sql devopshttps://pinboard.in/u:keithly/b:6a927848f83d/Trek10 | From relational DB to single DynamoDB table: a step-by-step exploration2019-01-08T15:53:18+00:00
https://www.trek10.com/blog/dynamodb-single-table-relational-modeling/
keithlyaws database nosql sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:0baab36dc57a/Modern SQL: A lot has changed since SQL-922018-02-19T19:28:08+00:00
https://modern-sql.com/
keithlysql database programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:e10d38eb1ead/A Minimalist Guide to SQLite2017-12-03T03:09:20+00:00
http://tech.marksblogg.com/sqlite3-tutorial-and-guide.html
keithlydatabase sql programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:b6a07b6db0ae/Datasette: instantly create and publish an API for your SQLite databases2017-11-30T03:47:05+00:00
https://simonwillison.net/2017/Nov/13/datasette/
keithlypython sql programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:9c81a4f41cf5/Simplex Sigillum Veri - Getting the Most out of Sqlite3 with Python2017-10-27T20:30:29+00:00
https://remusao.github.io/posts/2017-10-21-few-tips-sqlite-perf.html
keithlypython sql programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:53762a495784/Franchise: a sql notebook2017-09-27T02:15:38+00:00
https://franchise.cloud/
keithlydatabase sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:68f60ec30088/Literate SQL using the WITH clause2017-07-02T02:46:08+00:00
http://modern-sql.com/use-case/literate-sql
keithlyprogramming database sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:624d19364314/Writing more legible SQL Craig Kerstiens2016-11-23T14:48:38+00:00
http://www.craigkerstiens.com/2016/01/08/writing-better-sql/
keithlyprogramming sqlhttps://pinboard.in/u:keithly/b:b5c2e3039d70/PostgreSQL Exercises2016-07-31T17:50:14+00:00
https://pgexercises.com/
keithlysql tutorial postgreshttps://pinboard.in/https://pinboard.in/u:keithly/b:a668b82b101a/Five mistakes beginners make when working with databases Craig Kerstiens2016-06-15T19:33:58+00:00
http://www.craigkerstiens.com/2016/06/07/five-mistakes-databases/
keithlydatabase sql programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:855c2214ba82/A thorough guide to SQLite database operations in Python2016-06-14T21:01:40+00:00
http://sebastianraschka.com/Articles/2014_sqlite_in_python_tutorial.html
keithlydatabase python sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:50e3eb61df73/SQL: The Prequel (Excel vs. Databases)2016-05-31T16:10:19+00:00
https://github.com/veltman/learninglunches/tree/master/databases
keithlysql excel databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:44219c1268e2/SQL Joins Visualizer2016-04-12T02:33:16+00:00
http://sql-joins.leopard.in.ua/
keithlysql visualizationhttps://pinboard.in/https://pinboard.in/u:keithly/b:44668a0834dd/Industry Data Models2016-04-11T02:41:48+00:00
http://www.databaseanswers.org/data_models/index.htm
keithlydatabase programming reference sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:ba53f27b0b9a/SQL Injection Cheat Sheet by Netsparker2016-03-27T23:03:00+00:00
https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/
keithlydatabase security sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:4a0bc5a92f2b/Readings in Database Systems, 5th Edition2015-12-10T01:04:07+00:00
http://www.redbook.io/
keithlydatabase sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:d212f719a68d/Facebook and Amazon Have Huge Islands of Data. How Can They Come Together? | New Republic2015-12-05T22:42:51+00:00
https://newrepublic.com/article/124425/dreamed-perfect-database
keithlydatabase sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:7b0d7fa07f4a/How does a relational database work - Coding Geek2015-09-01T02:21:31+00:00
http://coding-geek.com/how-databases-work/
keithlydatabase sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:20cd0e81507c/SQL style guide by Simon Holywell2015-07-28T19:36:00+00:00
http://www.sqlstyle.guide/
keithlydatabase sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:c8f6048a1288/Khan Academy Computing: New course: Learn SQL interactively on Khan Academy2015-05-12T19:45:11+00:00
http://cs-blog.khanacademy.org/2015/05/just-released-full-introductory-sql.html
keithlysql tutorialhttps://pinboard.in/https://pinboard.in/u:keithly/b:599970a81be1/SQL Teaching - The easiest way to learn SQL2015-05-12T19:37:18+00:00
http://www.sqlteaching.com/
keithlysql database tutorialhttps://pinboard.in/https://pinboard.in/u:keithly/b:6f2fecabd644/Models for hierarchical data2015-05-05T15:16:57+00:00
http://www.slideshare.net/billkarwin/models-for-hierarchical-data
keithlydatabase sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:c507346bce73/Keeping it Simple: Rendering Trees with Closure Tables2015-05-05T15:14:33+00:00
http://karwin.blogspot.com/2010/03/rendering-trees-with-closure-tables.html
keithlysql databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:f80b8d9be20b/SQLBolt - Learn SQL with simple, interactive examples2015-05-03T01:27:28+00:00
http://sqlbolt.com/
keithlydatabase sql tutorial programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:25ed6fa8fce9/A Visual Explanation of SQL Joins2015-04-10T13:17:20+00:00
http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/
keithlysql database visualizationhttps://pinboard.in/https://pinboard.in/u:keithly/b:c4240c7f7a61/Goodbye MongoDB, Hello PostgreSQL | Hacker News2015-03-15T03:54:10+00:00
https://news.ycombinator.com/item?id=9178773
keithlysql ormhttps://pinboard.in/https://pinboard.in/u:keithly/b:4638329aa741/It’s Time To Get Over That Stored Procedure Aversion You Have — Rob Conery2015-02-23T23:00:50+00:00
http://rob.conery.io/2015/02/21/its-time-to-get-over-that-stored-procedure-aversion-you-have/
keithlydatabase orm sql development ranthttps://pinboard.in/https://pinboard.in/u:keithly/b:c2c6350cb43c/SQL Indexing Tutorial | Use The Index, Luke!2015-02-23T03:56:34+00:00
http://use-the-index-luke.com/
keithlysql database performancehttps://pinboard.in/https://pinboard.in/u:keithly/b:cfab87fd217b/Show HN: SQL Teaching – Codecademy for SQL | Hacker News2015-02-20T14:16:02+00:00
https://news.ycombinator.com/item?id=9072842
keithlysqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:6e454ada0f6f/What is the optimal size for variable width columns? | About Sql Server2015-02-09T22:04:22+00:00
http://aboutsqlserver.com/2010/08/18/what-is-the-optimal-size-for-variable-width-columns/
keithlysql sql-serverhttps://pinboard.in/https://pinboard.in/u:keithly/b:c36dfa40b5ef/Typical Programmer - Why Programmers Don’t Like Relational Databases2014-11-23T23:12:06+00:00
http://typicalprogrammer.com/why-programmers-dont-like-relational-databases
keithlydatabase sql nosqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:2da603899035/A Simple Guide to Five Normal Forms in Relational Database Theory (1982) | Hacker News2014-09-29T19:43:58+00:00
https://news.ycombinator.com/item?id=8381674
keithlysql data databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:cd584b832b19/How To Improve the Performance of TPT Inheritance Mapping in Entity Framework | Falafel Software Blog2014-08-12T14:28:53+00:00
http://blog.falafel.com/how-to-improve-the-performance-of-tpt-inheritance-mapping-in-entity-framework/
keithlyentity-framework orm sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:186b3b944e3e/Introduction to Database Management Systems2014-08-10T22:51:21+00:00
http://philip.greenspun.com/sql/introduction.html
keithlyprogramming sql databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:7ea596af1d9a/Interoperability Happens - The Vietnam of Computer Science2014-08-09T21:06:28+00:00
http://blogs.tedneward.com/2006/06/26/The+Vietnam+Of+Computer+Science.aspx
keithlyorm database programming sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:e0599a4eef69/What ORMs have taught me: just learn SQL - Curried lambda2014-08-07T02:11:08+00:00
http://wozniak.ca/what-orms-have-taught-me-just-learn-sql
keithlyorm sql database programminghttps://pinboard.in/u:keithly/b:86fd2e2b5246/T-SQL Books2014-08-07T02:10:26+00:00
http://tsql.solidq.com/books/index.htm
keithlybooks sql sql-serverhttps://pinboard.in/https://pinboard.in/u:keithly/b:fbeee15d7fed/Searching for Strings in SQL Server Databases2014-04-23T15:56:59+00:00
https://www.simple-talk.com/sql/t-sql-programming/searching-for-strings-in-sql-server-databases-/
keithlysql sql-server searchhttps://pinboard.in/https://pinboard.in/u:keithly/b:e0c2cdaa2edc/Why You Should Never Use MongoDB | Hacker News2014-04-20T02:37:34+00:00
https://news.ycombinator.com/item?id=6712703
keithlynosql sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:596938bdc2d3/10 Easy Steps to a Complete Understanding of SQL - Tech.Pro2013-09-03T15:18:09+00:00
http://tech.pro/tutorial/1555/10-easy-steps-to-a-complete-understanding-of-sql
keithlysqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:96fb11343a95/SQLZOO2012-11-07T16:04:12+00:00
http://sqlzoo.net/wiki/Main_Page
keithlytutorial sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:c3187c1892d7/Hipsters hacking on PostgreSQL • The Register2012-10-18T14:28:27+00:00
http://www.theregister.co.uk/2012/08/31/postgresql_too_cool_for_school/
keithlypostgres sql nosqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:5459c7f48696/Navicat - PostgreSQL For Mac OS X - Navicat is the World's Best MySQL, SQL Server, SQLite, SQL Azure, Oracle & PostgreSQL database administration tool - Download Now!2012-10-17T17:15:06+00:00
http://www.navicat.com/en/products/navicat_pgsql/pgsql_detail_mac.html
keithlypostgres sqlhttps://pinboard.in/https://pinboard.in/u:keithly/b:c39dd6a19fc1/sqlkorma2011-11-03T15:11:58+00:00
http://sqlkorma.com/
keithlyprogramming sql clojurehttps://pinboard.in/https://pinboard.in/u:keithly/b:c9f227fe04c4/