Jackson Miller's Bookmarks Tagged With "sql"

SecurityDocs: Comment on SQL Injection Attack and Defense

http://www.securitydocs.com/library/3587
- Rated 5 stars out of 5.
- Details
includes suggested SQL Injection attack strings. This is a great resource for testing your apps.
- Tags: SQL, security
- Saved by Jackson Miller on December 12, 2007.
What is the result of comparing NULL with NULL? | Oracle FAQ

http://orafaq.com/faq/what_is_the_result_of_comparing_null_with_null
- Not rated yet.
- Details
In Oracle, two columns that are both NULL are not considered equal. It is one of those things that you can pretty much only learn by making a mistake. It bit me in the ass a little today, but I was able to catch it before it made it into production.
- Tags: oracle, database, sql, development
- Saved by Jackson Miller on December 12, 2006.
Rails: Generate SQL from Migrations

http://jayfields.blogspot.com/2006/11/rails-generate-sql-from-migrations.html
- Not rated yet.
- Details
Jay Fields described using Rails Migrations to generate the DDL and SQL for migrations even if you don't run those migrations directly to the database. This is how we did things on a project I worked on in the past. It works well. Unfortunately, not ma
- Tags: database, migrations, RoR, rubyonrails, sql, Rails
- Saved by Jackson Miller on November 13, 2006.