Why use Constraints in SQL ?
Constraints enables business rules to be enforced by the database instead of via application code. Through the judicious use of constraints,... more »
6 commentsSave Tags: .net, database, perl, php
Complex Event Processing with Esper
Automated analysis of real-time data plays an increasingly important role in our society. Real-time or near real-time systems in a variety of domains... more »
0 commentsSave Tags: database, frameworks, java, server
Server Side Java Script - CRUD on Jaxer
SSJS Rocks! I'm a fan of Server Side JavaScript (SSJS) and databases (sure, that's an odd combination, but hey, this is a geek zone). In any case,... more »
0 commentsSave Tags: database, javascript
PHP Object-Relational Mapping: ORM or ROM?
This article talks about what is Object-Relational Mapping (ORM). It also talks about PHP ORM solutions that can make you more productive by allowing... more »
2 commentsSave Tags: database, frameworks, methodology, php
The Manga Guide to Databases???
IWho comes up with this? A dummies for dummies book? In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data... more »
0 commentsSave Tags: books, database, how-to, opinion
sqlmap: a SQL injection tool
sqlmap is an automatic SQL injection tool developed in Python. Its goal is to detect and take advantage of SQL injection vulnerabilities on web... more »
1 commentsSave Tags: database, python, security, tools
MySQL Cofounder David Axmark Leaving Sun
David Axmark, a cofounder and former lead engineer for MySQL, has resigned from Sun Microsystems a few weeks after another cofounder said he may also... more »
1 commentsSave Tags: database, news
The Spring Jdbc Template - Tutorial
This article describes the usage of the Spring JDBC Template in a standalone application.
0 commentsSave Tags: database, how-to, java
Temporary Tables - SQL For Programmers
You may think that you don’t need a temporary table. But, if you’ve ever retrieved data from your database retrieved data from a table and put it in... more »
1 commentsSave Tags: database, how-to, microsoft
Use criterias to enhance the search of your DAOs
In most cases your DAOs needs some search methods and most developers are usually creating numerous of methods to perform all types of different... more »
0 commentsSave Tags: database, java
Hibernate ORM can lead to inflexibility; Terracotta can help
But the thing I noticed is, there’s just no avoiding the fact that whatever your domain POJO’s are that need to be persisted, chances are good that... more »
0 commentsSave Tags: database, frameworks, java
SQL - What are your favorite performance tricks?
When you have a query or stored procedure that needs performance tuning, what are some of the first things you try?
0 commentsSave Tags: database, opinion
Creating an ASP.NET Newsletter Application
A tutorial to create a newsletter application for your website. It allows users to subscribe and unsubscribe from the newsletter. A simple online... more »
0 commentsSave Tags: .net, database, how-to, other languages
How to Fix MySQL Database (MyISAM / InnoDB)
So... your shiny MySQL database is no longer running and you want to fix it? You've come to the right place! I've assembled a list of 7 ways to... more »
1 commentsSave Tags: database, how-to, php, server
How and Why to Use Parameterized Queries
A parameterized query is a query in which placeholders are used for parameters and the parameter values are supplied at execution time. The most... more »
0 commentsSave Tags: database, how-to, microsoft, php
Two improvements to your Capfiles
Capistrano tips from one of the few Capistrano masters.
0 commentsSave Tags: database, php, ruby
Using the New MySQL Query Profiler
Create high-performing SQL code as well as assist in troubleshooting existing queries that aren't providing the response times you'd like.
0 commentsSave Tags: database, how-to, open source, tools
LINQ to TEXT and LINQ to CSV
This post presents my current approach for dealing with text files using LINQ, and includes a function for splitting CSV lines.
0 commentsSave Tags: .net, database, how-to, tools
Where to go for Java DB Questions
While Java DB is Sun's distribution of Apache Derby, we do not maintain a separate users' forum for it outside of the Apache Derby users'... more »
0 commentsSave Tags: database, java
Introduction to NHibernate: What does NHibernate bring to the table
A short screencast introduction to NHibernate: In this episode we will talk about what does NHibernate bring to the table
0 commentsSave Tags: .net, database, frameworks, how-to
4GL Patterns
Why study patterns from 4GL applications? Writing 4GL applications yields a lot of productivity clues that may be applicable to programming at... more »
0 commentsSave Tags: database, frameworks
Hibernate Sessions in Two Tier Rich Client Applications
An article about an aproach to hibernate session handling in two tier applications.
2 commentsSave Tags: database, research
10 Useful articles about Database design
This is a list of ten useful articles about database design which includes some tips and practical suggests to help you to design quickly databases... more »
2 commentsSave Tags: database, how-to, methodology, php
The first JBoss Cache 3.0.0 CR is now available
Manik is looking for feedback on the new features and performance characteristics, including: performance under load, performance in large clusters,... more »
0 commentsSave Tags: announcement, database, open source, tools
Pointers and Vectors and Lists, OH MY!
The two questions that I needed to solve were: 1. How do I store these collections of information? 2. How do I reference... more »
0 commentsSave Tags: database, games, how-to
