(Juan Fajardo) This article is a tutorial on how to create a CRUD (Create, Retrieve, Update and Delete) Form using SharpDevelop and PostgreSQL, implementing a BindingNavigator to explore the table used in the application. We will be using SharpDevelop 3.1, PostgreSQL 8.3 for Windows, and of course N

(Chris) Consider excluding the following grants from users on any production MySQL server.

(Umang Gopani) Here is the list of errors I have faced while importing a 25G .sql file into my cluster setup.

(Sarah Sproehnle) For easy MySQL failover, replication is a great solution. This post will cover the basics of performing a failover in case your master dies.

(Leo Hsu and Regina Obe) Vacuuming and analyzing is the process that removes dead rows and also updates the statistics of a table. As of PostgreSQL 8.3, auto vacuuming (the process that runs around cleaning up tables), is on by default. If you are creating a lot of tables and bulk loading data, the

(Chris) In the past I have needed to gain access to MySQL servers when the password had been strangely forgotten. Below there are thee different processes to gain access to MySQL if you just don’t have the right kind of access you need or want.

(Shlomi Noach) The InnoDB plugin has a nice INFORMATION_SCHEMA concept: resetting tables. For example, the INNODB_CMP table lists information about compression operation. A similar table, INNODB_CMP_RESET, provides the same information, but resets the values. The latter can be used to measure, for e

(CalvinHartwell) When working with technologies such MySQL, developers should aim to correctly sanitize input, as such systems can be easily exploited. This guide is not thorough and I expect the reader to have prior knowledge of both PHP and MySQL.

(Sarah Sproehnle) This post describes how MySQL Cluster executes queries. First of all, Cluster is a storage engine. It doesn’t actually execute queries because it doesn’t speak SQL. That is why you use a MySQL server, which parses your queries and sends low-level storage engine API calls to the Clu

(yves) After having reviewed the definition my the previous post (The definitions), the next step is to respond to some questions.