Handy SQL with IntelliJ IDEA
If a project you are working on requires referring to an SQL database, you can, actually, use one of the numerous SQL clients, or type commands in the... more »
0 commentsSave Tags: database, tools
Using a Hibernate Interceptor To Set Audit Trail Properties
Using a simple Hibernate Interceptor, updating audit trail fields in a database (such as created_by, created_on, updated_by, and updated_on) can be... more »
0 commentsSave Tags: database, frameworks, java
Sharding destroys the goals of your relational database
bloid 
via stephan.reposita.org
Sharding does destroy your relational database - which is a good thing. The idea behind sharding is to distribute data to several databases based on... more »
0 commentsSave Tags: database, opinion
Database Algorithm: Sequencing Dependencies
Some database applications require you to perform a series of actions where you know only that some actions must be performed before others. Before... more »
0 commentsSave Tags: database, how-to
Simplify ActiveRecord Aggregates And Other Goodies Via named_scope
Using the Rails 2.1 named_scope feature just for simplifying find conditions is like using a Swiss Army Knife only as a screwdriver.
0 commentsSave Tags: database, open source, ruby
Full-text search using JBoss Seam, Hibernate and Lucene
Most sites that need to do full-text search of their content start with a simple "select * from blog where content ilike '%queryString%';". That... more »
0 commentsSave Tags: database, java
Database Explorer in NetBeans 6.5
NetBeans 6.5 contains some cool new features like "tabbed result set", "sql history" and more. This article explores them in detail.
0 commentsSave Tags: database, open source, tools
CRUD with PHP Doctrine
Somewhat more than trivial CRUD interface with PHP Doctrine.
0 commentsSave Tags: database, how-to, php
MySQL: Multiple column index vs multiple indexes
bloid via mysqlperformanceblog.com
After my previous post there were questions raised about Index Merge on Multiple Indexes vs Two Column Index efficiency. I mentioned in most cases... more »
0 commentsSave Tags: database
Latency is Everywhere and it Costs You Sales - How to Crush it
Latency matters. Amazon found every 100ms of latency cost them 1% in sales. Google found an extra .5 seconds in search page generation time dropped... more »
0 commentsSave Tags: database, how-to, tools, web services
Using GORM outside of Grails
The author explains how he got GORM to work outside of Grails - with the latest version.
0 commentsSave Tags: database, frameworks, groovy
My Website's SQL Database was Hacked
I received an email from my website manager indicating several errors across different pages. I hate days that start with issues like that, I first... more »
0 commentsSave Tags: database, reviews, security
Are foreign keys really necessary in a database design?
Many people responded and there were all kinds of opinions. The strange thing I noticed was that many people including Joel Spolsky do not use foreign... more »
1 commentsSave Tags: database, opinion
Epictetus 0.3.1 beta: Database Desktop Manager
Epictetus is a free cross platform database tool based on the NetBeans Platform. The new release works with Oracle, MSSQL, MySQL, Firebird, HsqlDB,... more »
0 commentsSave Tags: database, java
101 Reasons Why PostgreSQL is a better fit for Rails than MySQL
Explaining why PostgreSQL is a better fit for Rails than MySQL
0 commentsSave Tags: database, reviews, ruby
High Performance MySQL: Review
bloid via mysqldbnews.blogspot.com
This is not the book if you are trying to learn about databases in general. The book assumes that you have at least some hands on experience in your... more »
0 commentsSave Tags: books, database, reviews
MySQL WorkBench - A great tool for your databases
A great tool for working with mysql database
5 commentsSave Tags: database
MySQL 6.0.6 Alpha Released Introduces Maria
MySQL 6.0.6-alpha, a new version of the MySQL database system has been released and intoduces two new storage engines most interesting Maria.
0 commentsSave Tags: announcement, database, server
Database Best Practices
Every production application I have been involved with has made use of a database. As a programmer, you don’t have to be a DBA, but just as with... more »
5 commentsSave Tags: database, how-to, opinion, standards
Backup Your MySQL Database Using PHP
One of the most important tasks any developer needs to do often is back up their MySQL database. In many cases, the database is what drives most of... more »
5 commentsSave Tags: database, how-to, php
Should you cache?
bloid via dormando.livejournal.com
Memcached's popularity is expanding its use into some odd places. It's becoming an authoritative datastore for some large sites, and almost more... more »
0 commentsSave Tags: database, opinion
Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?
Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing. The following... more »
0 commentsSave Tags: database
MySQL asynchronous balancing with HTTP+JSON
bloid via blogs.sun.com
It is almost the same. It solves the same problem, it does the same work, it looks quite similar, but there is a difference though. One of them is... more »
1 commentsSave Tags: database, frameworks
AppJet databases now faster and more powerful.
You might like to know that AppJet, the cloud-based JavaScript framework that nobody knows about, just released an update, making it more efficient... more »
0 commentsSave Tags: database, javascript
Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code
Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code. In this case the query run time went from 24 hours+ to 36... more »
0 commentsSave Tags: .net, database, how-to, opinion
