death to sql server (part 4)
I’ve written about this before, but to rehash … the date functions inside SQL server suck. What’s really weird is that there’s an undocumented way to retrieve out certain datetime… Read more »
Category: Databases
postgresql functions
One thing I love about (advanced) databases is that you can write functions. They speed up the query time quite a bit, and you can do fun stuff like IF… Read more »
portage in postgresql
Well, I’m bored, so I figured I’d spill the beans on a project I’ve been keeping under wraps for a while. I’ve been working on getting everything about the portage… Read more »
sql vs. sql
Once again, UPHPU has had a minor stir about which database is faster / better / stronger, PostgreSQL or MySQL. All fanboyism aside, who really cares? You want to know… Read more »
death to sql server (part 3)
It’s been a good while that I’ve ranted and raved against MS SQL Server. I’ve actually found a few bugs since then, I just haven’t documented them. My beef this… Read more »
what did I ever do without views?!
There are some things in life that, once you get used to them … there’s just no going back. Things like underwear, Malt-O-Meal, Neverwinter Nights, and views. At work we… Read more »
gentoo, php, and vhosts
Well, I just finished migrating all my webapps on my server to using the ‘vhosts’ flag. Which, really isn’t that many — just my blog, trac, and internal stuff. For… Read more »
database first impressions
I’ve spent almost all day trying to get these free versions of large databases working. Well, that, and watching a good amount of Justice League. So far, I’ve yet to… Read more »
more lds-scriptures releases coming soon (hopefully)
I’m sure I’m going to get into trouble by announcing something I *plan* on releasing, because then I might never get around to it … but oh well, I felt… Read more »
death to sql server (part 2)
This one isn’t a rant, just another head-scratching-that’s-an-odd-thing-to-do kind of post. One of the main scripts was running slow tonight that gets hit on a regular basis, and we couldn’t… Read more »