DBMS Category

AutoMySQLBackup: Regularly Backup Your MySQL

AutoMySQLBackup: Regularly Backup Your MySQL

If you have blogs or websites, you databases is one the most important thing. Your data will be store on your database, for this case it is MySQL. MySQL is a free database management system (DBMS) and... [More...]

Backup All Your MySQL Database With One Script

Backup All Your MySQL Database With One Script

MySQL is a relational database management system (RDMS), and one of the most powerful DBMS. Most of the websites including this blog using MySQL technology behind it. Since it free and it always bundled... [More...]

[HowTo] Extract Database Information From Information_schema Table in Mysql

[HowTo] Extract Database Information From Information_schema Table in Mysql

INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes... [More...]

[HowTo] Replace String In Mysql With One Query

[HowTo] Replace String In Mysql With One Query

Yesterday i was helping my friend’s blog. She want to change her domain and move her hosting server for some reasons. She is using wordpress as her blog engine and of course using mysql as database... [More...]

[HowTo] Make User Defined Function In SQLite ADO.NET With C#

[HowTo] Make User Defined Function In SQLite ADO.NET With C#

Sometime we want to make user defined function and use it in our query to the database. In Ms. SQL Server and Oracle DBMS support user defined function, stored procedure and transactional. Since SQLite... [More...]

[HowTo] Use SqLite ADO.NET with C#

[HowTo] Use SqLite ADO.NET with C#

SQLite is software library written in C that implement self-contained (very minimal support from external libraries), serverless (read/write process directly to database file), cross-platform (run in... [More...]

[HowTo] Run ASP.NET on Linux With Apache Web Server (Mono + Mod_Mono)

Mono is an open source project led by Novell (formerly by Ximian) to create an Ecma standard compliant, .NET-compatible set of tools, including among others a C# compiler and a Common Language Runtime.... [More...]