http://shlomi-noach.github.io/blog/ Blog by Shlomi Noach Mon, 25 Mar 2019 10:48:45 +0000 en-US hourly 1 https://wordpress.org/?v=5.3.3 32412571 Some observations on MySQL to sqlite migration & compatibility https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility#comments Mon, 30 Jan 2017 09:14:33 +0000 https://shlomi-noach.github.io/blog/?p=7663 https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility/feed 4 7663 Three wishes for a new year https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-4 https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-4#comments Wed, 28 Sep 2016 14:20:54 +0000 https://shlomi-noach.github.io/blog/?p=7643 https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-4/feed 2 7643 SQL mini hack of the day, inverted IN clause https://shlomi-noach.github.io/blog/mysql/sql-mini-hack-of-the-day-inverted-in-clause https://shlomi-noach.github.io/blog/mysql/sql-mini-hack-of-the-day-inverted-in-clause#comments Fri, 13 Nov 2015 15:28:09 +0000 https://shlomi-noach.github.io/blog/?p=7451 https://shlomi-noach.github.io/blog/mysql/sql-mini-hack-of-the-day-inverted-in-clause/feed 2 7451 Leader election using MySQL https://shlomi-noach.github.io/blog/mysql/leader-election-using-mysql https://shlomi-noach.github.io/blog/mysql/leader-election-using-mysql#comments Wed, 14 Oct 2015 05:52:21 +0000 https://shlomi-noach.github.io/blog/?p=7384 https://shlomi-noach.github.io/blog/mysql/leader-election-using-mysql/feed 3 7384 Tool of the day: q https://shlomi-noach.github.io/blog/mysql/tool-of-the-day-q https://shlomi-noach.github.io/blog/mysql/tool-of-the-day-q#comments Thu, 08 Aug 2013 09:26:02 +0000 https://shlomi-noach.github.io/blog/?p=6417 https://shlomi-noach.github.io/blog/mysql/tool-of-the-day-q/feed 4 6417 Merging tables with INSERT…ON DUPLICATE KEY UPDATE https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update#comments Thu, 21 Feb 2013 12:12:48 +0000 https://shlomi-noach.github.io/blog/?p=6120 https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update/feed 3 6120 Hierarchical data in INFORMATION_SCHEMA and derivatives https://shlomi-noach.github.io/blog/mysql/hierarchical-data-in-information_schema-and-derivatives https://shlomi-noach.github.io/blog/mysql/hierarchical-data-in-information_schema-and-derivatives#comments Tue, 08 Jan 2013 11:19:56 +0000 https://shlomi-noach.github.io/blog/?p=5311 https://shlomi-noach.github.io/blog/mysql/hierarchical-data-in-information_schema-and-derivatives/feed 2 5311 Pop quiz: funny syntax https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax#comments Mon, 05 Nov 2012 18:22:15 +0000 https://shlomi-noach.github.io/blog/?p=5445 https://shlomi-noach.github.io/blog/mysql/pop-quiz-funny-syntax/feed 1 5445 Three wishes for a new year https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-201 https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-201#comments Sun, 16 Sep 2012 04:20:59 +0000 https://shlomi-noach.github.io/blog/?p=5398 https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-201/feed 3 5398 SQL: selecting top N records per group, another solution https://shlomi-noach.github.io/blog/mysql/sql-selecting-top-n-records-per-group-another-solution https://shlomi-noach.github.io/blog/mysql/sql-selecting-top-n-records-per-group-another-solution#comments Tue, 21 Aug 2012 04:49:43 +0000 https://shlomi-noach.github.io/blog/?p=5249 https://shlomi-noach.github.io/blog/mysql/sql-selecting-top-n-records-per-group-another-solution/feed 10 5249