Articles tagged database

How to Delete WordPress Post Revisions
WordPress has a nice little feature of saving revisions of your posts whilst you're editing them. This is great if you need to roll back to a previous revision. However, after you've published a post, it's unlikely you'll need the old revisions. Read more – ‘How to Delete WordPress Post Revisions’.
SQL User-Defined Function: ListToTable
A common need in SQL is the ability to iterate over a list as if it were an array. In SQL it is not possible to declare arrays, unlike other programming languages such as ColdFusion, ActionScript and Java. Fortunately, there is a way around this problem: use a User-Defined Functions (UDFs) to create a tabular version of the data. Arrays are, after all, essentially tabular data (at their simplest, one dimension level). Read more – ‘SQL User-Defined Function: ListToTable’.
SQL User-Defined Function: ReplaceChars
The SQL Replace function enables us to look for a certain character phrase in a string and replace it with another character phrase. The updated string is then returned by the function. Read more – ‘SQL User-Defined Function: ReplaceChars’.
Preventing SQL Injection in an AIR Application
SQLite is a mostly ACID-compliant relational database management system contained in a relatively small (~500kB) C programming library. The Adobe AIR runtime includes the SQLite embedded database for use by Adobe AIR applications. This allows applications to run and store data locally and or synchronise the datastore with online repositories. Read more – ‘Preventing SQL Injection in an AIR Application’.
How to Fix a SQL Injection Attack
In my previous post, What is a SQL Injection Attack, I gave a brief overview of SQL injection and Cross-Site Scripting (XSS), primarily with regard to websites. In the example given, we saw that an attack could take the form of a ‘hacked’ URL which contained either a literal SQL statement, or a hexadecimal string that could be interpreted by an insecure SQL database server. Read more – ‘How to Fix a SQL Injection Attack’.
Microsoft SQL Server 2005 JDBC Driver 1.2
Download the SQL Server 2005 JDBC Driver 1.2, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition). This release of the JDBC Driver is JDBC 3.0 compliant and runs on the Java Development Kit (JDK) version 1.4 and higher. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, JBoss, and Sun. Read more – ‘Microsoft SQL Server 2005 JDBC Driver 1.2’.
ColdFusion ORM Frameworks & Tools
Object-Relational Mapping (or ORM), is a programming technique that links databases to object-oriented language concepts, creating (in effect) a "virtual object database". There are both free and commercial packages available that perform object-relational mapping, although some programmers opt to code their own object-relational mapping for their systems. Read more – ‘ColdFusion ORM Frameworks & Tools’.