Pinboard (keithly)
https://pinboard.in/u:keithly/public/
recent bookmarks from keithlyHello, I'm Mr. Null. My Name Makes Me Invisible to Computers | WIRED2024-08-21T14:46:59+00:00
https://www.wired.com/2015/11/null/
keithlyprogramming null databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:f7a3f40b6813/Enhance database performance with Amazon RDS dedicated log volumes | AWS Database Blog2024-07-30T19:43:37+00:00
https://aws.amazon.com/blogs/database/enhance-database-performance-with-amazon-rds-dedicated-log-volumes/
keithlyaws databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:01981dc3a08c/Phil Eaton2024-07-04T04:26:26+00:00
https://eatonphil.com/
keithlyblog programming databasehttps://pinboard.in/u:keithly/b:d9eb4ebe0e19/UUIDv7 in 20 languages2024-06-18T14:43:36+00:00
https://antonz.org/uuidv7/
keithlyuuid programming database via:popularhttps://pinboard.in/u:keithly/b:6b19fecab3ec/About Pool Sizing · brettwooldridge/HikariCP Wiki2024-04-08T20:29:27+00:00
https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing
keithlydatabase performance java programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:50006a04ef4a/Glory is only 11MB/sec away2024-04-08T17:45:33+00:00
https://thmsmlr.com/cheap-infra
keithlycomplexity database programming devops awshttps://pinboard.in/https://pinboard.in/u:keithly/b:be9c0249b408/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/PostgreSQL® JSONB Cheatsheet: Complete & Fast Lookup Guide2023-04-15T16:08:13+00:00
https://aiven.io/developer/postgresql-jsonb-cheatsheet
keithlypostgres database jsonhttps://pinboard.in/https://pinboard.in/u:keithly/b:fecf30a74b56/Why You Should Never Use MongoDB « Sarah Mei2023-04-03T18:05:14+00:00
http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/
keithlydatabase mongodb nosql dev-architecturehttps://pinboard.in/https://pinboard.in/u:keithly/b:3e95cfdf5fd7/QGIS is the mapping software you didn't know you needed - Christian Hollinger2023-03-01T03:15:04+00:00
https://chollinger.com/blog/2023/01/qgis-is-the-mapping-software-you-didnt-know-you-needed/
keithlysoftware maps gis databasehttps://pinboard.in/u:keithly/b:1bf56e39e4b2/Choosing a Postgres Primary Key2023-01-23T19:39:33+00:00
https://supabase.com/blog/choosing-a-postgres-primary-key
keithlypostgres uuid databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:8e0d4381fdfd/Query Engines: Push vs. Pull2023-01-03T18:36:18+00:00
https://justinjaffray.com/query-engines-push-vs.-pull/
keithlydatabase programminghttps://pinboard.in/u:keithly/b:f952e23e251b/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/Things You Should Know About Databases2022-06-27T16:23:25+00:00
https://architecturenotes.co/things-you-should-know-about-databases/
keithlydatabase programminghttps://pinboard.in/u:keithly/b:e027420eca6c/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/Datasette: An open source multi-tool for exploring and publishing data2022-05-21T00:23:52+00:00
https://datasette.io/
keithlysqlite csv python database data programminghttps://pinboard.in/u:keithly/b:7cb1080edaa0/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/Back to basics: Writing an application using Go and PostgreSQL | Henrique Vicente2022-02-14T03:07:02+00:00
https://henvic.dev/posts/go-postgres/
keithlyprogramming database postgresql golanghttps://pinboard.in/u:keithly/b:38572267f074/Postgres is a great pub/sub & job server2021-12-20T19:50:24+00:00
https://webapp.io/blog/postgres-is-the-answer/
keithlydatabase pubsub postgres programminghttps://pinboard.in/u:keithly/b:a5d3a82f508c/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/What every software engineer should know about Apache Kafka | Hacker News2020-07-02T03:07:30+00:00
https://news.ycombinator.com/item?id=23206566
keithlydatabase streaming programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:cc9dd219eaaa/Your migrations are bad and you should feel bad - djrobstep.com2019-03-24T01:30:12+00:00
https://djrobstep.com/talks/your-migrations-are-bad-and-you-should-feel-bad
keithlydatabase postgres programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:cd9f477f6ef3/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/How not to structure your database-backed web applications: a study of performance bugs in the wild | the morning paper2018-07-16T23:33:13+00:00
https://blog.acolyer.org/2018/06/28/how-_not_-to-structure-your-database-backed-web-applications-a-study-of-performance-bugs-in-the-wild/
keithlyprogramming database webhttps://pinboard.in/https://pinboard.in/u:keithly/b:7117089edb56/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/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/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/dbpatterns - create, share, explore database patterns2016-04-11T22:09:10+00:00
http://dbpatterns.com/
keithlydatabase programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:7fb36fe72ab4/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/Testing with Data | Kyle Baley2016-01-20T18:02:41+00:00
http://codebetter.com/kylebaley/2015/11/19/testing-with-data/
keithlydatabase testing programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:9f6b78a4f057/Fieldbook: Create a database, as easily as a spreadsheet2015-12-23T18:29:25+00:00
https://fieldbook.com/developers
keithlyspreadsheet database uxhttps://pinboard.in/https://pinboard.in/u:keithly/b:1ea0c5e40f6d/Free Red Book: Readings in Database Systems, 5th Edition - High Scalability -2015-12-10T22:35:54+00:00
http://highscalability.com/blog/2015/12/9/free-red-book-readings-in-database-systems-5th-edition.html
keithlydatabase data-sciencehttps://pinboard.in/https://pinboard.in/u:keithly/b:42f992391678/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/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/Clean Tests: Isolating the Database | Jimmy Bogard's Blog2015-03-23T19:52:10+00:00
https://lostechies.com/jimmybogard/2015/03/02/clean-tests-isolating-the-database/
keithly.net testing development databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:ff070594e657/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/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/Why I love databases — Medium2014-11-13T23:59:11+00:00
https://medium.com/@jeeyoungk/why-i-love-databases-1d4cc433685f
keithlydatabasehttps://pinboard.in/https://pinboard.in/u:keithly/b:e57210f6b164/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/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/What the NSA can do with “big data” | Ars Technica2013-06-20T21:03:58+00:00
http://arstechnica.com/information-technology/2013/06/what-the-nsa-can-do-with-big-data/
keithlyprivacy nsa surveillance security databasehttps://pinboard.in/https://pinboard.in/u:keithly/b:dbc6c2e69dd3/Three things you should never put in your database | Revolution Systems2012-05-03T15:29:05+00:00
http://www.revsys.com/blog/2012/may/01/three-things-you-should-never-put-your-database/
keithlydatabase logging blob-storagehttps://pinboard.in/https://pinboard.in/u:keithly/b:4116bffd4512/Evolutionary Database Design2012-02-14T17:40:20+00:00
http://martinfowler.com/articles/evodb.html
keithlydatabase programminghttps://pinboard.in/https://pinboard.in/u:keithly/b:b887f4b87a84/Troy Hunt: The unnecessary evil of the shared development database2011-02-08T15:48:46+00:00
http://www.troyhunt.com/2011/02/unnecessary-evil-of-shared-development.html
keithlydatabase sql-server source-controlhttps://pinboard.in/https://pinboard.in/u:keithly/b:21770e1440b1/