Try Raven For Free

Archive for the ‘Databases’ Category

Getting Real With Databases in PHP

Thursday, June 1st, 2006
It’s no secret that I don’t like Ruby on Rails. My friends know it. My co-workers definitely know it. And I guess now you do, too. Ruby itself is a fine language, and there are lots of great web apps running on Rails, but the framework just doesn’t fit with my development style. I like to keep things simple. I’m too much of a control-freak to sell my soul to a particular framework. That said, many of the ideas behind Ruby on Rails are spot on. I particularly like how well it abstracts database queries into separate objects for each table. ...

http://raven-seo-tools.com/blog/2921/getting-real-with-databases-in-php

96,000 Reasons to Mine Your Data

Friday, November 11th, 2005
I just read a story in the paper about the local high school. They received a $96,000 correction to their natural gas bill after 8 years of service, “due to billing error at Harpeth High School.” Apparently, most gas customers in our area have meters that read in 100’s of cubic feet. Therefore the gas company bills per 100 cubic feet. But with a large building, like a school, they install bigger meters which read in 1000’s of cubic feet. On the billing side, they then multiply the meter reading by 10 to calculate usage. I’m ...

http://raven-seo-tools.com/blog/2554/96000-reasons-to-mine-your-data

Bootclean Whacked My Sockets

Monday, October 17th, 2005
PostgreSQL and MySQL can both use local sockets to handle communication between the client and the server. An indepth description of sockets can be found here, but basically they are special files that act like network connections. The difference is that instead of being available over the network, it’s only available locally. If you only use local connections, make sure you disable the network connections for increased security. PostgreSQL’s local socket looks something like this: srwxrwxrwx 1 postgres postgres 0 Oct 17 16:57 /tmp/.s.PGSQL.5432 And MySQL’s looks like this: srwxrwxrwx 1 mysql daemon ...

http://raven-seo-tools.com/blog/2549/bootclean-whacked-my-sockets

Social
Raven News
Recent