https://pinboard.in/u:WimLeers/public/ recent bookmarks from WimLeers 2021-05-03T08:34:40+00:00 https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/ WimLeersdatabase sqlite http https://pinboard.in/u:WimLeers/b:26155f3cbb49/ 2021-02-22T09:51:07+00:00 https://simonwillison.net/2021/Feb/21/cross-database-queries/ WimLeerssqlite database https://pinboard.in/ https://pinboard.in/u:WimLeers/b:a2ce0758c457/ 2021-02-16T10:36:40+00:00 https://news.ycombinator.com/item?id=26151302 WimLeers berkes 12 minutes ago [–] This is very similar in Rails. Only in Rails it is far easier to accidentally introduce interfaces that do this: the downside of having a very easy DSL to quickly add relations between records/tables is that people very quickly add relations between records/tables: introduce spaghetti. And in Rails it is very hard to debug, because ActiveRecord tries hard to be smart, but this "smart" quickly degrades into "black magic" when stuff gets complex (mostly caused by: see above, in my experience). Edit: currently working on a codebase where 3000ms queries to get 200 items is no exception, where 500+ queries to build a page is common and where, if you change a foo on a bar, suddenly at the other end of the app, your blargs and blazzes start blurping out SQL that used to run 200ms but now adds some wheres and limits and group-bys that make it run over 2000ms. Yay for Rails trying to help!/s ]]> performance orm database rails sql https://pinboard.in/ https://pinboard.in/u:WimLeers/b:a19ffcc63d21/ 2020-05-30T13:57:26+00:00 https://twitter.com/mortensonsam/status/1266007142235947009 WimLeersdatabase samuelmortenson datastructures https://pinboard.in/u:WimLeers/b:d9d768fc08b5/ 2018-05-17T22:40:36+00:00 http://www.colinsteele.org/post/27929539434/60000-growth-in-7-months-using-clojure-and-aws WimLeers This led to Decision Two. Because the data set is small, we can “bake in” the entire content database into a version of our software. Yep, you read that right. We build our software with an embedded instance of Solr and we take the normalized, cleansed, non-relational database of hotel inventory, and jam that in as well, when we package up the application for deployment. Egads, Colin! That’s wrong! Data is data and code is code! We earn several benefits from this unorthodox choice. First, we eliminate a significant point of failure - a mismatch between code and data. Any version of software is absolutely, positively known to work, even fetched off of disk years later, regardless of what godawful changes have been made to our content database in the meantime. Deployment and configuration management for differing environments becomes trivial. Second, we achieve horizontal shared-nothing scalabilty in our user-facing layer. That’s kinda huge. Really huge. ]]> programming scalability database datastructures https://pinboard.in/u:WimLeers/b:0fb6ff0891b3/ 2018-05-01T22:55:34+00:00 https://www.youtube.com/watch?v=oLGYMdo2q2g WimLeerssql database foundationdb acid 2014 https://pinboard.in/ https://pinboard.in/u:WimLeers/b:aaaee2533a80/ 2014-11-20T06:18:02+00:00 http://blog.memsql.com/cache-is-the-new-ram/ WimLeersperformance database history cache disk cpu ram memsql mustread carlosbueno https://pinboard.in/u:WimLeers/b:dd437ff8bcd9/ 2014-02-20T20:15:18+00:00 http://sqlmap.org/ WimLeerssecurity database sql https://pinboard.in/ https://pinboard.in/u:WimLeers/b:2aa312816fec/ 2013-09-19T22:33:00+00:00 http://www.quora.com/What-are-the-major-differences-between-LSM-trees-used-in-BigTable-etc-and-Fractal-Trees-used-in-TokuDB WimLeersdatabase datastructures algorithms https://pinboard.in/ https://pinboard.in/u:WimLeers/b:8808c5cab05c/ 2012-09-25T13:16:51+00:00 http://highscalability.com/blog/2012/9/24/google-spanners-most-surprising-revelation-nosql-is-out-and.html WimLeers database google sql nosql https://pinboard.in/ https://pinboard.in/u:WimLeers/b:937f619365bf/ 2012-09-18T11:49:35+00:00 http://drupal.stackexchange.com/questions/27932/how-to-implement-substring-in-db-select-statement WimLeersdrupal drupal7 database https://pinboard.in/ https://pinboard.in/u:WimLeers/b:5c9756099103/ 2012-07-02T06:06:14+00:00 http://renormalize.org/post/24114553409/like-akiban-googles-newest-database-uses-table-groups WimLeersgoogle database sql https://pinboard.in/u:WimLeers/b:a884cdd7075f/ 2012-07-01T12:11:52+00:00 http://martinfowler.com/bliki/OrmHate.html WimLeersdatabase orm sql algorithms reference https://pinboard.in/u:WimLeers/b:3dc632aa04d9/ 2012-06-30T07:25:31+00:00 http://techcrunch.com/2012/06/27/citus-data-launches-new-scalable-analytics-database/ WimLeersdatabase datamining https://pinboard.in/u:WimLeers/b:390ba41e745a/ 2012-06-28T08:09:07+00:00 http://www.sqlite.org/src4/doc/trunk/www/design.wiki WimLeersdatabase sqlite https://pinboard.in/ https://pinboard.in/u:WimLeers/b:87229655a89c/ 2012-05-30T16:38:59+00:00 http://research.google.com/pubs/pub38125.html WimLeerssql database google nosql mysql https://pinboard.in/ https://pinboard.in/u:WimLeers/b:cae896047719/ 2012-05-11T15:13:21+00:00 http://saucelabs.com/blog/index.php/2012/05/goodbye-couchdb/ WimLeerssql nosql mysql couchdb database https://pinboard.in/ https://pinboard.in/u:WimLeers/b:792ec9bcf7d9/ 2012-04-04T10:34:33+00:00 http://techportal.ibuildings.com/2011/01/11/database-version-control/ WimLeersdatabase sql vcs https://pinboard.in/u:WimLeers/b:5fb9fc5bb3b5/ 2011-11-24T04:02:20+00:00 http://cr.yp.to/cdb.html WimLeersdatabase sqlite programming djb djbernstein https://pinboard.in/ https://pinboard.in/u:WimLeers/b:183b65525dba/ 2011-03-03T12:58:54+00:00 http://opentsdb.net/ WimLeersschool school:master-thesis database opentsdb scalability realtime datamining https://pinboard.in/u:WimLeers/b:3ee04785f42a/ 2011-01-23T10:34:27+00:00 http://open.blogs.nytimes.com/2007/12/21/a-first-look-at-amazon-simpledb/ WimLeersdatabase erlang aws https://pinboard.in/u:WimLeers/b:b260fb7452f2/ 2010-12-16T07:38:54+00:00 http://www.facebook.com/note.php?note_id=470667928919 WimLeersdistributed database join performance hadoop hive https://pinboard.in/u:WimLeers/b:9734f5b50992/ 2010-12-14T16:32:09+00:00 http://antirez.com/post/redis-virtual-memory-story.html WimLeersredis database performance memory school school:master-thesis memcached nosql reference https://pinboard.in/u:WimLeers/b:892c9b7b877b/ 2010-12-14T15:58:16+00:00 http://simonwillison.net/static/2010/redis-tutorial/ WimLeersnosql redis database performance school school:master-thesis simonwillison https://pinboard.in/u:WimLeers/b:c0b2ce4625e7/ 2010-11-30T18:13:11+00:00 http://crackingdrupal.com/blog/greggles/creating-sanitized-drupal-database-dump WimLeersdrupal database backup reference https://pinboard.in/u:WimLeers/b:f36e74520d8a/ 2010-11-30T18:12:42+00:00 http://www.subzin.com/ WimLeersmovies database https://pinboard.in/u:WimLeers/b:bdf7faab4379/ 2010-11-27T20:13:34+00:00 http://www.scribd.com/doc/28849826/Scaling-MySQL-writes-through-Partitioning WimLeersmysql database performance school school:master-thesis episodes boomerang https://pinboard.in/u:WimLeers/b:bdce505abc1b/ 2010-11-18T18:31:09+00:00 http://www.lullabot.com/articles/querying-slave-database-with-views WimLeersdrupal drupal:views scalability performance database https://pinboard.in/u:WimLeers/b:79b370fcf18e/ 2010-11-01T18:19:04+00:00 http://twitter.com/#!/bendiken/status/29388501922 WimLeersjava database performance redis https://pinboard.in/u:WimLeers/b:971061b7f580/ 2010-09-26T18:00:54+00:00 http://www.theregister.co.uk/2010/09/24/google_percolator/ WimLeersgoogle database mapreduce algorithms scalability distributed https://pinboard.in/u:WimLeers/b:7a6e314cc617/ 2010-09-10T12:21:09+00:00 http://www.theregister.co.uk/2010/09/09/google_caffeine_explained/ WimLeersgoogle mapreduce algorithms database 2010 history google:caffeine https://pinboard.in/u:WimLeers/b:9055340dce80/ 2010-09-05T18:36:14+00:00 http://cassandra.apache.org/ WimLeersepisodes school school:master-thesis database apache cassandra distributed opensource scalability https://pinboard.in/u:WimLeers/b:232449b87c6e/ 2010-09-01T00:40:59+00:00 http://github.com/scor/dgb WimLeersstephanecorlosquet drupal git database backup https://pinboard.in/u:WimLeers/b:6d8d5d5c6da6/ 2010-03-02T22:17:54+00:00 http://tweakers.net/nieuws/65910/twitter-verruilt-mysql-voor-cassandra.html WimLeersdatabase mysql cassandra school school:master-thesis https://pinboard.in/u:WimLeers/b:8b863ee12ddd/ 2010-01-24T14:23:47+00:00 http://dikini.net/24.10.2009/microbenchmarking_php_streams_includes_from_database_vs_standard_includes WimLeersdrupal php database https://pinboard.in/u:WimLeers/b:b684058079a3/ 2009-12-29T23:17:35+00:00 http://railstips.org/2009/12/18/why-i-think-mongo-is-to-databases-what-rails-was-to-frameworks WimLeersmongodb database https://pinboard.in/u:WimLeers/b:f1a0cd70b2fe/ 2009-10-28T11:04:27+00:00 http://www.allthingsdistributed.com/2009/10/amazon_relational_database_service.html WimLeersmysql database aws https://pinboard.in/u:WimLeers/b:efbb4bd25e11/ 2009-09-02T11:56:16+00:00 http://therealadam.com/archive/2009/08/31/its-not-nosql-its-post-relational/ WimLeerssql database datastructures future history technology https://pinboard.in/u:WimLeers/b:dfef36ea0fa8/ 2009-07-06T16:00:54+00:00 http://www.garfieldtech.com/blog/orm-vs-query-builders WimLeersdrupal php database orm https://pinboard.in/u:WimLeers/b:82b6e7dcb220/ 2009-04-21T23:20:27+00:00 http://labs.mozilla.com/2009/04/towards-better-browser-storage/ WimLeersdatabase browser sql html5 https://pinboard.in/u:WimLeers/b:e92b5b925332/ 2009-03-17T21:47:17+00:00 http://highscalability.com/are-cloud-based-memory-architectures-next-big-thing WimLeersdatabase storage performance architecture grid cloud distributed memcached future technology https://pinboard.in/u:WimLeers/b:557cbc7fb4b6/ 2009-02-17T23:08:39+00:00 http://fourkitchens.com/blog/2009/02/17/developer-preview-materialized-views WimLeersdrupal database drupal:views https://pinboard.in/u:WimLeers/b:d3afab0eff43/ 2008-12-31T01:44:26+00:00 http://www.maxmind.com/app/country WimLeersgeolocation service software development database i18n php python C++ https://pinboard.in/u:WimLeers/b:f36aac37e4c7/ 2008-12-02T22:40:17+00:00 http://cleanupdata.com/#video WimLeersdatabase web2.0 innovation https://pinboard.in/u:WimLeers/b:9148b125621f/ 2008-08-29T12:14:35+00:00 https://community.continuent.com/community/tungsten-replicator WimLeersmysql performance database https://pinboard.in/u:WimLeers/b:dfbc4e1c6f95/ 2008-08-29T12:14:29+00:00 http://www.maatkit.org/ WimLeersmysql performance database https://pinboard.in/u:WimLeers/b:e6a34523e540/ 2008-07-16T08:06:34+00:00 http://www.codinghorror.com/blog/archives/001152.html WimLeersdatabase normalization sql performance https://pinboard.in/u:WimLeers/b:a3dd5c738e30/ 2008-07-06T17:26:53+00:00 http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSIntro WimLeersRDF SPARQL database https://pinboard.in/u:WimLeers/b:f0c724f8f913/ 2008-05-07T22:38:43+00:00 http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB WimLeersdatabase MySQL Drupal Performance https://pinboard.in/u:WimLeers/b:0a5a32129bc8/ 2008-04-30T15:40:09+00:00 http://www.sitepoint.com/article/hierarchical-data-database/2 WimLeershierarchical database sql tree https://pinboard.in/u:WimLeers/b:b178273896d0/ 2008-04-29T13:29:54+00:00 http://phpsqldiff.sourceforge.net/ WimLeersdatabase changemanagement https://pinboard.in/u:WimLeers/b:82ccbaf62c31/ 2008-04-29T13:26:16+00:00 http://codebaboon.com/method-syncronising-database-changes WimLeersdrupal changemanagement mysql database https://pinboard.in/u:WimLeers/b:52e3dba7240d/ 2008-04-28T23:06:00+00:00 http://codinginparadise.org/weblog/2005/10/javascript-sql-database-with-permanent.html WimLeersjavascript database https://pinboard.in/u:WimLeers/b:701b3b90d66f/ 2008-04-28T22:50:51+00:00 http://www.hackszine.com/blog/archive/2008/04/relational_database_using_jque.html WimLeersdatabase jquery funny https://pinboard.in/u:WimLeers/b:2b769ae71d29/ 2008-04-05T00:53:03+00:00 http://glazkov.com/blog/html5-gears-wrapper/ WimLeershtml5 sql database javascript webkit google google:gears https://pinboard.in/u:WimLeers/b:d9b85f44dada/ 2008-03-19T18:58:57+00:00 http://www.pointy-stick.com/blog/2008/03/11/queryset-implementation/ WimLeersdatabase SQL orm programming python django https://pinboard.in/u:WimLeers/b:5e9263a77bdc/ 2008-03-19T10:08:09+00:00 http://troels.arvin.dk/db/rdbms/#select-top-n WimLeers sql database reference https://pinboard.in/u:WimLeers/b:414a25e46d35/ 2008-03-14T18:19:15+00:00 http://www.mysqlperformanceblog.com/2008/03/13/economics-of-performance-optimization/ WimLeersdatabase mysql optimization performance https://pinboard.in/u:WimLeers/b:e01997e8fe63/ 2008-02-18T09:20:17+00:00 http://ssdisk.eu/benchmark_pc_extreme_raid.php WimLeersssd benchmark database mysql raid https://pinboard.in/u:WimLeers/b:9dbc117cc3a8/ 2008-02-08T18:20:37+00:00 http://www.phpdoctrine.org/ WimLeersdatabase orm php SQL webdev dbal pdo https://pinboard.in/u:WimLeers/b:19f4d9b469de/ 2008-02-08T18:20:12+00:00 http://www.drupal4hu.com/node/120 WimLeersdrupal database dbal orm https://pinboard.in/u:WimLeers/b:fbe34dc1c139/ 2008-02-07T00:03:36+00:00 http://googledocs.blogspot.com/2008/02/stop-sharing-spreadsheets-start.html WimLeersdatabase google web2.0 https://pinboard.in/u:WimLeers/b:a4f8cf95b11d/ 2007-11-27T20:10:34+00:00 http://www.slideshare.net/vishnu/scaling-early WimLeershttp web scalability database https://pinboard.in/u:WimLeers/b:c2189e3b51ff/ 2007-08-26T18:41:32+00:00 http://www.khankennels.com/blog/index.php/archives/2007/04/20/getting-joins/ WimLeerssql database join reference https://pinboard.in/u:WimLeers/b:89ec5b2fbf3b/ 2007-06-18T17:02:12+00:00 http://dabbledb.com/explore/7minutedemo/ WimLeersdatabase ajax webdev web2.0 https://pinboard.in/u:WimLeers/b:af18b0f52cfc/