databases
&
life
Newest
Categories
Random
Contact & Follow:
RSS
Email
GitHub
StackOverflow
LinkedIn
Twitter
Categories
> Databases
“Just-in-time” inserting rows into a database
Circular dependencies on Foreign Key constraints (Oracle)
Constraint name visibility on MySQL and PostgreSQL
Creating an Iterator for a streaming JDBC ResultSet in Java
Databases are fast at INSERTs! 1¼ minutes to insert 1¼ million rows (on a test server!)
Difference between row-level locking algorithms on Oracle and MySQL InnoDB
Don’t use string constants when writing SQL statements in code
If you’re going to change databases, do it in one go
On “we don’t need these users—let’s move them to an archive table!”
Oracle, Nulls and the empty string
PostgreSQL vs MySQL “update” difference
Primary keys only need to be unique; there’s many characteristics they often have but don’t need to have
Put SQL together with the code that uses it
Store Users’ Birth Dates, Not Ages, in the Database
The
SUM(col)
of zero rows should zero, but is instead
NULL
Use the “Repeatable Read” Isolation Level on PostgreSQL
WebTek: Unique constraints and the
alreadyexists
error
XML in the database
CHAR
vs
VARCHAR
(and
VARCHAR2
)
COUNT(*)
vs
COUNT(pk_col)