(Jonathan Levin) I made a new tutorial for how to use MySQL to develop Big Data Applications.
Tag: Open Source
Adding read capabilities to a Foreign Data Wrapper
(Par Guillaume Lelarge) In the first article, we talked about the minimum required functions to be able to add a foreign data wrapper to a PostgreSQL database. Alas, we couldn’t do much with it, as it didn’t have other capabilities. And one of the most interesting capabilities of a FDW is to access
Postgres 9.3 feature highlight: Data Checksums
(Michael Paquier) Data checksums is a new feature introduced in PostgreSQL 9.3, adding a new level of checksum to protect data from disk and I/O corruption, controlled directly by the database server. This has been introduced by the commit below.
Waiting for 9.4 – ALTER TABLE … ALTER CONSTRAINT for FKs
(depesz) Basically whole purpose of this patch is described in the commit message, but let’s see how that works.
Resolving Missing sys Include Files: devpoll.h, epoll.h, event.h, and queue.h during CMake when Building MySQL on Windows
(Chris Calender) As I mentioned in a previous post that I’d mention how I resolved some additional missing include files when building MySQL on Windows.
Pivoting in Postgres
(Craig Kerstiens) Earlier today on an internal Heroku group alias there was a dataclip shared. The dataclip listed off some data grouped by a category, there was a reply a few minutes later with a modification to the query that used the crosstab function to pivot directly in SQL. There were immediat
MySQL Proxy and microseconds
(Ronald Bradford) By default the included Lua within MySQL proxy (0.8.3) does not include socket, necessary for getting microsecond granularity. To setup you have to install Lua and socket on the OS first:
Postgres devel: some psql tricks
(Michael Paquier) psql, the command client delivered with postgres core, has many options and is in this way highly customizable. For example, you can use a ~/.psqlrc file to upload automatically some customized settings when launching psql. Here are some general tips to be aware off as a common use
Converting MyISAM to InnoDB and a lesson on variance
(morgan tocker) I’m about to start working through converting a large MySQL installation to InnoDB. For the particular use case durability is desired, and with MyISAM a loss of power almost certainly guarantees data loss. Durability is not available as an option.
The handler and the validator functions of a FDW
(Par Guillaume Lelarge) I’m still working on my foreign data wrapper. Actually, I haven’t written a lot of code. Instead, I’ve been reading the code of the other foreign data wrappers and it helped me a lot to understand many things, and to see how far each went.