(Richard K. Blum) In the past, using open source databases meant running UNIX (or Linux) servers and open source development environments. Today however, the two most popular open source database packages – MySQL and PostgreSQL – have full featured Windows installations, and can be run on most Windo
Tag: Open Source
PostgreSQL cheat sheet
(Lorenzo Alberton) While there is already a number of cheat sheets for Postgresql available on the web, I couldn’t find one in this format and with the kind of information I wanted, so I wrote one.
MyODBC Connector – Part 3: Create a New Project
(Matthew R. King) Open Visual Studio and start a new project. I am calling mine “MyStore” in the example below.
MySQL wants to build ‘database in the sky’
(Juan Carlos Perez) MySQL AB wants to launch a global project to build a massive, distributed repository containing all of the world’s data now stored in structured databases, the company’s chief executive officer said.
MyODBC Connector – Part 2: Initial Steps
(Matthew R. King) Warning – I am breezing through these steps. I want to get to the “meat” of the tutorial, which is the databound controls. Besides, most of the downloads come with installation instructions, and Mike Hillyar explains most of this better than I can.
MySQL Scale-Out by Application Partitioning
(Oli Sennhauser) Eventually every database system hits its limits. Especially on the Internet, where you have millions of users which theoretically access your database simultaneously, eventually your IO system will be a bottleneck. (pdf)
MyODBC Connector – Part 1: Introduction
(Matthew R. King) This step-by-step tutorial takes the reader through the process of using databound controls in VB.NET using the MyODBC Driver to connect to a MySQL database. We will start by creating a very basic and simple MySQL database, then connect to it and bind controls from within Visual Ba
PHP and Accessing MySQL Database Data
(Blair Ireland) If you are new to the TheScripts.com series of tutorials on PHP and MySQL tutorials, I will restate a few things…
Design And Implementation Of Temporal Triggers For MySQL RDBMS
(Andrey Jordanov Hristov) There exist on the market dozens of relational database management systems (RBDMS) and every organization that creates such a product tries to add more and more features to provide a superior product. Having more features brings more customers and therefore allows the compa
Managing Hierarchical Data in MySQL
Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hier