Articles in database

  1. Defending PHP Web Applications from MySQL - MySQL provides a number of features that can be used to greatly increase the security of your PHP application.
  2. Is Oracle Data Encrypted on the Wire? - Determine if queries and responses to and from Oracle databases (which occur over TCP port 1512 by default) were encrypted.
  3. Connecting to MySQL from Oracle SQL Developer -
  4. Dump all data from a MySQL database into a tab delimited file - This is a simple script that will dump all the data out of a MySQL database.
  5. MySQL Database User Security - All too often, especially on small setups, database security is ignored.
  6. Backing up MySQL Remotely with Rsync and SSH - Implementing a MySQL backup solution utilizing mysqldump, secure shell (SSH), public key access (PKA), rsync and a remote server.
  7. Loading Data into MySQL from a Text File - Short article on loading text into a MySQL database from a plain text file. This operation is remarkably fast and easy, especially for data migration.
  8. Executing MySQL via Textpad - Instructions on how to execute MySQL commands on a local database directly from within TextPad.
  9. Posting to MySQL with TextPad - You can document the data model as you actually create it. This is wonderful news for anyone that has had to spec up a data model, then create it, then reverse engineer a text document that describes the model.
  10. MS Acces to Oracle via ODBC - Instructions on connecting Microsoft Access to Oracle using ODBC.
  11. Using Oracle's SQL Developer from Mandriva - This article provides instructions to get SQL Developer working and connecting to a remote Oracle host behind a firewall.
  12. Setting up a Linux MySQL server for Windows clients - Quick setup notes for connecting Windows client machines to a MySQL server.
  13. Using Squirrel SQL to connect to your MySQL database - Brief instructions on how to set up Squirrel SQL Client as a GUI for your MySQL server.
  14. MySQL Max Allowed Packet Size Exceeded Fix - Solving the MySQL max_allowed_packet size exceeded error.
  15. Creating an Oracle .WAR file for deployment - Instructions for building a WAR to deploy a .jsp only application (no beans or whatever) through the Oracle management web interface.
  16. Backing Up and Restoring MySQL Databases - Backing up and restoring a MySQL database.
  17. Using Soundex with MySQL - A description of SOUNDEX and how to use its functionality in MySQL.
  18. Designing a Data Driven Website - Part II - Data modeling, building a solid foundation for your data driven site.
  19. MySQL Beginners Guide - A comprehensive training white paper desinged to get you started with MySQL, including installation and use.
  20. Show Every (x)day for the Year - A short script to show every x number day in a given year.