MySQL Archives - Page 3 of 3

Connect to SqlCe (SQL Server Compact) database from ASP

03/06/2013

Connect to SQL Server Compacy (SqlCe) database with ASP. Here is how to install the Microsoft.SQLSERVER.CE.OLEDB.4.0 Provider and use classic ASP to connect to an SqlCe (SQL Server Compact) database sdf file, as a Microsoft Access database replacement. For Windows Server IIS. SQL Server Compact (SqlCe), the embedded database engine, is the default database for Visual Studio 2010 SP1 and WebMatrix 3. This means, it’s recommended to use SqlCe over Access nowadays.

Web applications

MySQL Connector/NET and Entity Framework

26/02/2013

How to let MySQL Connector/NET, ASP.NET and Entity Framework play nicely. Set up and check your Web.config website configuration

Code base

Cache MySQL query results with PHP WinCache

14/02/2013

You can cache and store the MySQL query result in your web server RAM memory, utilizing PHP WinCache. Or another PHP opcode cache like Opcache for that matter. This’ll increase database and PHP performance.

Code base

Calculate MySQL database size with PHP (off the old shelf)

09/02/2013

Calculate the MySQL database size in PHP. Sometimes you’d be amazed what you find when cleaning out your old script archives. I found an old PHP script to calculate the size of a MySQL database. I post it here just for the fun of it.

WordPress

WordPress HyperDB is an advanced database class that supports replication

20/07/2012

HyperDB database class. HyperDB: an advanced database class for WordPress, that supports replication and partition of data. HyperDB is a replacement for the standard wpdb class, which adds the ability to use multiple databases. HyperDB supports partition of data as well as replication.

Umbraco

Umbraco CMS admin password reset

17/11/2011

If you forgot your Umbraco admin password, use the following SQL query to reset your Umbraco admin password in SQL Server Management Studio (SSMS) or MySQL

Code base

MySQL query caching using PHP/Zend_Cache

14/11/2011

By using the Cache.php PHP class of the Zend Framework, you can relatively easy cache MySQL query results to disk. This ensures faster consecutive results and speeds up execution. In this context, caching means: execute a MySQL query once and save the result in a temporary file. For every time that same query is executed, you can simply use the result stored in your disk cache file, as long as the database hasn’t changed. Often it is faster to save this on the web server than having it to redo the query every time.