PostgreSQL
Coming Attractions
DBAs meet and Portland Ignites
0 comments
Share our glory:
Couple of events going down in the Portland area over the next week or two that all the cool kids are going to attend (i.e. me and any other nerds who can sneak past their mom/wife/partner/WoW).
PostgreSQL Conference Fall 2007Ah, PostgreSQL... The Other White Meat. Or, at least, the Other Open Source DB. Those cooky kids are throwing their little conference at Portland State University in the heart of increasingly-less-sunny-as-fall-hits-its-stride Stumptown this coming Saturday, October 20th. You need to preregister and scrounge up sixty tax-de...
End-of-Life for PostgreSQL 8.0 on Windows
Share our glory:
Woke up this morning to find a message in my inbox from the PostgreSQL pgsql-announce listserv with the subject "PostgreSQL 8.0, 8.1 on Windows End-of-Life." Pretty self-explanatory.
According to the announcement, no more updates for those versions on the Windows platform will be released once version 8.3 hits the shelves later this year. They recommend that anybody using one of those versions start thinking about upgrading as soon as possible.
Normally, we don't like to just parrot news readily available from other sources, but I didn't see this particul...
Oh, Joy! More JOINs!
JOINing Tables in INSERT, UPDATE, and DELETE Queries
Share our glory:
In our last SQL post, we talked about the three basic types of JOINs enterprising young SQL junkies might use to gather data from different tables in their databases.
"Enterprising..." Oh, how I crack myself up some times. Seriously. Don't make me explain why that's funny.
Anyway, in between Star Trek-related examples, we blabbed on and on about INNER JOINs, three kinds of OUTER JOINs, and the almost completely useless CROSS JOIN. You might remember, though, that every one of those brilliant examples involved querying existing data with SELECT statements. T...
JOIN the Dark Side
Share our glory:
When you've been playing around with SQL for awhile, you start to take your knowledge of JOINs for granted. When someone asks you about JOINing data from two or more tables together, you get this stunned look on your face... You know, the same one you get when you actually hear someone mutter the words "I've never seen 'Star Wars'." You forget that you, too, once didn't know a JOIN from a Jedi, and that everyone has to start somewhere.
So let's talk about JOINs. Like the name implies, a JOIN is simply a method for connecting two tables in a database, usually through so...
LIMIT, OFFSET, and TOP
Get the Range of Data You Really Want
Share our glory:
Let's say you have a table that contains the monthly figures for your army of sales people. At the end of every month, the sales manager asks you to pull a list of his top ten performers from the previous period. What do you do? Well, you could just pull the entire list, ORDER BY the month, and manually count off the top ten. That query might look something like this:
SELECT salesperson_name, sales_total FROM salesdata
WHERE sales_month =
- Definitely.
2 weeks 1 day ago - A Brief Word About Shared Hosting: No
2 weeks 5 days ago - It ignores them in an
2 weeks 6 days ago - Great Work Dude (:
2 weeks 6 days ago - I hear ya...
3 weeks 44 min ago - IE Specific CSS
3 weeks 13 hours ago - Thanks
4 weeks 15 hours ago - Blocks
5 weeks 1 day ago - I'm using VS 2008 and I'm
7 weeks 5 days ago - Case sensitive
8 weeks 11 hours ago
Be sure to check out the latest from Smashing Magzine. They have a great article on CSS Specifity. Might be a review for some but still a good read.
Did you know that you can apply more than one element to a DIV or Class? This allows you to specify different styles to one class without the need for another DIV or Class on that element. Saves on code bloat as well.
Have a look at this article for a better explanation and example.