Lets examine the notion that SQLite can be a viable replacement for fopen(). To get your understanding, SQLite is an implementation of a database engine that is self contained, serverless, transactional and needs no configuration. On the Other hand fopen() is a function from the standard C library that opens a file for either reading and/or writing and returns a stream associated with that file.

MariaDB, is the MySQL forked database Server that uses the Maria storage engine as the default transactional and non-transactional storage engine. The Maria storage engine is no longer called “Maria” but is now called “Aria”. Any future versions of MariaDB will now ship with the default storage engine named “Aria”.

Knowing that MariaDB in the simplest terms, is an alternative to MySQL database server; the world’s most popular open source relational database management system. MariaDb has its source code made publicly available from Launchpad, MariaDB remains an open and free version of MySQL database. MariaDB runs on both Linux and Unix based operating systems as well as Windows.

A simple answer to that question is, MySQL Workbench visual database design tool developed by MySQL which is a cross-platform. MySQL Workbench is the successor to DBDesigner4 and is available for Windows (XP, VISTA & 7), Linux and Mac OSX. It comes distributed in two Licensing options, which are Open Source and Standard Edition.

Here comes the third article in the SQLyog for MySQL series of articles. Today we will deal with the various ways you can insert data into a MySQL database or MariaDB database using SQLyog, which is a powerful MySQL manager and administration tool that can also be used to manage MariaDB database.

Ever seen a DBA having to deal with an application developers naive mistakes? Or could it simply be a case of developers just not knowing what should be done on a database and why it should be done. This issues arise straight from poor uses of SQL statements to sheer negligence in the total design of databases.

The question of when SQLite should be used and when MySQl should be used has come up again and again. To know when and where it is appropriate to use either SQLite or MySQL databases management systems, it is first and foremost important to know what the difference is between them, if at all there is any difference.

SQLyog is definitely a great and must have tool for any serious MySQL developer and database administrator. I would recommend going for either the SQLyog Enterprise Edition or the SQLyog Ultimate Edition so as to get the full benefits of using SQLyog to manage your MySQL databases.

Backing up MySQL databases may not be as easy as it seems to the not so tech savvy users using the native MySQL client. An alternative is SQLyog. See how easy it can get.

Seeing its slightly over a month since MariaDB 1.5 Beta was released for Linux and a couple of days now since the Windows Win32 Version came into being I felt it prudent to mention a little a bit about it for now. So to start off I’d like to mention about it’s history. For starters [...]