Mark W the SQL Geek

Opinions, experiences and information about SQL and the databases that process the language, from a guy who's been at it for over 20 years.

Monday, March 07, 2016

In database news today!

Microsoft takes on Oracle, opening up database software to Linux

What's next? Cats and dogs living together?
on March 07, 2016
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

  • The Benefits of Using Row Constructors! [MySQL]
      In the world of SQL, sometimes you need to conjure up rows of literal data out of thin air, instead of pulling data from an existing table...
  • Playing SQL Mythbuster - or - I really ought to lay off the SQL on social media
    Often, when I visit SQL-related forums and social media, I encounter posts that are half-truths, overgeneralizations, and sometimes, outrigh...
  • Pgpool-II Load Balancing
    NOTE: this post is surely hopelessly out of date. It is from 2011! I say this because the post is still getting views well over a decade lat...
  • What have Oracle Materialized Views got that PostgreSQL ones don't?
    This comes up once in a while. Just because DBMS x has a Feature ABC, doesn't mean it's the same as Feature ABC on DBMS y. Below is ...
  • Common Table Expressions: Postgres vs. Oracle vs. MySQL
    NOTE: I see this post still gets views, but it is very old and out of date. MySQL has now had CTEs since 8.x and they work pretty well. ...
  • "In Which We Are Not Having Fun"
    Speaking of Postgres materialized views... The guys at sparkfun (makers of Arduino as well other fine products) migrated from MySQL to Postg...
  • Standard SQL, Shmandard SQL
    I find the concept of "Standard SQL" - referring to these magical ANSI/ISO/IEC/whatever documents that spec out how SQL is suppose...
  • Arrays vs. IN-lists in SQL Using JDBC: Techniques and a Glance Under the Hood
    Intro: Alright, so say you want to run a query that has the WHERE clause WHERE id IN (...) from your Java program, using JDBC, where the co...
  • JUST. BIND.
    I saw this BBC article yesterday - These unlucky people have names that break computers  - it's about people with names such as Jennifer...
  • What does Postgres do better than MySQL?
    Here's a bit of an essay I wrote, originally on Reddit, on what does Postgres do that MySQL doesn't? It's not comprehensive - ju...

Pages

  • Home
  • Privacy Policy
  • Cookie Policy

Labels

postgresql (46) postgres (45) oracle (36) MySQL (28) reference (16) MS SQL (10) SQL Server (7) performance (7) materialized views (5) AskTom (4) CTEs (4) SQL injection (4) ddl (4) window functions (4) Java (3) Tom Kyte (3) common table expressions (3) pl/sql (3) recursive query (3) BoobyTrap (2) Evil MySQL Feature (2) JDBC (2) SQL here != SQL There (2) db2 (2) diff (2) foreign keys (2) generate series (2) indexes (2) just bind (2) locking (2) rant (2) series (2) sqlplus (2) with recursive (2) ANSI (1) Books (1) INSERT IGNORE (1) ISO (1) JOOQ (1) JSON (1) MATCH_RECOGNIZE (1) REPLACE INTO (1) Sybase (1) bind variables (1) bonkers (1) bug (1) caching (1) cartoon (1) character sets (1) clustering (1) collations (1) column store (1) constructing rows (1) db-engines (1) distinct on (1) dynamic columns (1) incremental refresh (1) inheritance (1) installation (1) joins (1) key-value (1) length (1) linux (1) locks (1) mariadb (1) merge (1) microsoft (1) optimizations (1) parallel (1) parameterization (1) pivot (1) preparedstatement (1) query rewrite (1) quiz (1) random (1) row constructor (1) row pattern matching (1) sequences (1) shared memory (1) standard SQL (1) sucks (1) trick (1) unpivot (1) versioning (1) whygod (1) wonky (1)

About Me

My photo
MWrynn
Self-proclaimed SQL geek whose career has largely focused on SQL, and the database software that processes the language, in one form or another since 2003. Motto: "When in doubt, test it out."
View my complete profile

Blog Archive

  • ►  2025 (9)
    • ►  November (1)
    • ►  September (2)
    • ►  August (1)
    • ►  July (1)
    • ►  May (4)
  • ►  2024 (5)
    • ►  December (2)
    • ►  September (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2023 (3)
    • ►  November (3)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (3)
    • ►  August (2)
    • ►  January (1)
  • ►  2019 (9)
    • ►  October (1)
    • ►  June (4)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2018 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (3)
    • ►  August (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2017 (6)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
  • ▼  2016 (17)
    • ►  November (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (2)
    • ▼  March (4)
      • MySQL, auto_increment and the magic number 0
      • JUST. BIND.
      • In database news today!
      • Dan Martensen's blog: SQL Performance of Join and ...
    • ►  February (3)
    • ►  January (1)
  • ►  2015 (11)
    • ►  December (1)
    • ►  May (1)
    • ►  March (5)
    • ►  February (4)
  • ►  2014 (8)
    • ►  September (1)
    • ►  August (2)
    • ►  March (3)
    • ►  February (2)
  • ►  2013 (12)
    • ►  December (1)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  April (1)
    • ►  March (3)
  • ►  2012 (4)
    • ►  August (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (24)
    • ►  December (1)
    • ►  November (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (3)
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (2)
  • ►  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2008 (1)
    • ►  December (1)
  • ►  2007 (6)
    • ►  July (2)
    • ►  May (1)
    • ►  April (3)

Report Abuse

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Search This Blog

Once again: I should lay off the SQL discussions on social media

Popular Posts

  • The Benefits of Using Row Constructors! [MySQL]
      In the world of SQL, sometimes you need to conjure up rows of literal data out of thin air, instead of pulling data from an existing table...
  • Playing SQL Mythbuster - or - I really ought to lay off the SQL on social media
    Often, when I visit SQL-related forums and social media, I encounter posts that are half-truths, overgeneralizations, and sometimes, outrigh...
  • Pgpool-II Load Balancing
    NOTE: this post is surely hopelessly out of date. It is from 2011! I say this because the post is still getting views well over a decade lat...
Watermark theme. Powered by Blogger.