Frustrated with soft deletes in SQL, Reeditor writes:
In the past, I’ve added a deleted_at (datetime) column and appended “WHERE deleted_at IS NULL” to every query involving that table. But it’s a total pain in the ass, and it’s complicated as shit: there’s always a few queries that are missed, a few developers [...]
“Hello World” is the first program one usually writes when learning a new programming language. The first Hello World program appeared in chapter 1.1 of the first edition of The C Programming Language, in 1978. Since then, Hello World has been implemented in just about every programming language on the planet.
The Hello World collection includes [...]
A good overview of the most common types of database backups and how they compare to each other.
Related articles:Oracle Database Architecture in Less than 10 Minutes (Video)
Rewriting SQL Queries for Performance in 9 Minutes (Video)
Oracle Performance Monitoring in Less than 12 Minutes (Video)
On the weekend of May 22, 2010, the Portland Development community is coming together in a way never experienced before. Using the University of Portland campus, SQLSaturday, Portland Code Camp, and Portland Bar Camp are combining and coordinating efforts to bring 800-1000 regional technology professionals together for the opportunity to immerse themselves in seminars, presentations, [...]
This article provides a set of simple techniques for preventing SQL Injection vulnerabilities. These techniques can be used with practically any kind of programming language with any type of database. There are other types of databases, like XML databases, which can have similar problems (e.g., XPath and XQuery injection) and these techniques can be used to protect them as well.
As a software developer, you certainly have a high-level picture of how web apps work and what kinds of technologies are involved: the browser, HTTP, HTML, web server, request handlers, and so on.
In this article, we will take a deeper look at the sequence of events that take place when you visit a URL.
The 2010 CWE/SANS Top 25 Most Dangerous Programming Errors is a list of the most widespread and critical programming errors that can lead to serious software vulnerabilities. They are often easy to find, and easy to exploit. They are dangerous because they will frequently allow attackers to completely take over the [...]
The following is a list of database limits which are divided into four categories in addition to the PL/SQL compiler limits. It is an aggregation of 5 separate web pages from the Oracle Database 11g Release 2 documentation library. I put them all here on one page for convenience.
Datatype Limits
Datatypes
Limit
Comments
BFILE
Maximum size: 4 GB
Maximum [...]
Great advice from Mitch Joel: Too many people are looking for too many ways to follow too many people and places. Your best bet is to do the opposite. Don't add more noise to your life. start removing the noise. It's not important to follow every Blog, and it's impossible to listen to every Podcast. If you've spent more than five minutes on Twitter, the river of tweets and the speed with which they flow makes every conversation look, feel and last a couple of seconds (at most). Become a better filter. If you're following someone and they're really not adding any value to your life (your growth, development and education), drop them. If you follow a Blog but never get to it because life happens, drop it. If you're a publisher of content (text, audio, video, images, whatever…) think about what you're publishing (noise vs. value).