Archive for the ‘Databases’ Category

Learn how to delete a PostgreSQL database (through a video)

Tuesday, August 18th, 2009
Managing your databases is a complex process including a few basic manipulation operations. In our previous posts you were acquainted with the steps for creating a database and a table, if working with PostgreSQL. All instructions were supported by…

Read the rest of Learn how to delete a PostgreSQL database (through a video)

Tags: ,
Posted in Databases | No Comments »

PostgreSQL databases – the new-generation back-end solution for contemporary dynamic websites

Wednesday, May 27th, 2009
PostgreSQL is the preferred new-generation database software for the creation of a growing number dynamic websites today. It is popular as a free alternative to powerful yet expensive corporate applications, allowing a great freedom in handling databases through a wide range of in-built features like defined-by-user objects, Multi-Version Concurrency Control (MVCC), database triggers,etc.

Read the rest of PostgreSQL databases - the new-generation back-end solution for contemporary dynamic websites

Tags: , , , , , , , ,
Posted in Databases | No Comments »

What to expect from the newest version of MySQL – MySQL 6.0

Saturday, May 9th, 2009
No modern website focused on the intuitive onsite experience of the visitors can exist without a good database at its backbone. Since the availability of dynamic content on a website has become a criterion for the website’s usability, boosting the amount of visitors attracted to its pages, database solutions…

Read the rest of What to expect from the newest version of MySQL - MySQL 6.0

Tags: , , , , , , , , , ,
Posted in Databases | No Comments »

Keep your dynamic web content by regular database backups! Watch our videos on how to create a MySQL dump file and restore a database

Sunday, April 26th, 2009
Today’s dynamic websites such as e-commerce stores, community sites, blogs, forums, etc. rely heavily on content and taking care of the content’s security must be a regular priority task for site owners. Since dynamic content is stored in SQL databases – all basic content security operations should…

Read the rest of Keep your dynamic web content by regular database backups! Watch our videos on how to create a MySQL dump file and restore a database

Tags: , , , , , , , , , , ,
Posted in Databases | No Comments »

See how to insert date in a MySQL table to efficiently organize your dynamic website contents

Wednesday, April 22nd, 2009
Learning how to handle MySQL databases in the easiest way possible has been the main subject of our recent few posts here, the last one of which was focused on managing MySQL databases through phpMyAdmin. Since managing a MySQL database and a…

Read the rest of See how to insert date in a MySQL table to efficiently organize your dynamic website contents

Tags: , , , , , , , ,
Posted in Databases | No Comments »