Login Tags
All Links » database

Top 20+ MySQL Best Practices

Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.

All Links » database

SQL is Dead. Long Live SQL

Outside of programming language flame wars, few questions raise the hackles of hackers more than: “how should I store my data?”

All Links » database

US Senators Give Ellison a Hand

59 US Senators signed a request this week asking the European Commission to expedite its investigation of the Oracle-Sun deal. The letter was addressed to the EU's head US delegate, Angelos Pangratis. The signatories, led by Senators John Kerry (D) and Orrin Hatch (R), came from both Democratic and Republican parties.

All Links » database

SQL Tutorial in simple and easy steps

Learn SQL in simple and easy steps using this tutorial. SQL is a database computer language designed for the retrieval and management of data in relational database.

All Links » database

Database Connections in PHP (MSSQL, MySQL, MDB, XLS Connections)

We can use mysql_connect and mysql_select_db functions to create our connections. For closing the connections there is mysql_close function. These are basic functions of managing connections in PHP. There are also a lot of classes made by developers for free.

All Links » database

Mindscape LightSpeed an O/R Mapper Done Right

This is a brief tutorial on Mindscape LightSpeed, an O/R Mapper which is super easy to setup and use. I am using on a project now and wanted to share how simple it is to use, compared to something like Entity Framework from Microsoft.

Login

Filter by Tags