Question about SQL - GoFuckYourself.com

theking · 09-06-2003, 01:41 AM

I have never used an SQL data base before...but I have seen literally hundreds of sites that have SQL errors. Can someone explain why this is. Is it the fault of the server...the programmer...or is SQL shaky?

KC · 09-06-2003, 01:47 AM

Quote:

Originally posted by theking
I have never used an SQL data base before...but I have seen literally hundreds of sites that have SQL errors. Can someone explain why this is. Is it the fault of the server...the programmer...or is SQL shaky?

Most likely caused by shitty programming and/or lack of maintenance. SQL is a powerful class of relational databases. I'd estimate 99% of all interactive sites on the net use some sort of SQL based backend..

LuSiD · 09-06-2003, 02:27 AM

Some SQL errors, like "Too many connections," show up all too often, but these are always caused by poor configuration and/or programming. But databases aren't, in general, just "shaky", whether they are MySQL, PostgreSQL, SQL Server, Oracle, blah blah blah... and once you work out the issues you are having, they come in real handy!

I live for dynamic content.

Mutt · 09-06-2003, 02:31 AM

i've always noticed the same thing with dynamic sites using mySQL, GFY included, lots of errors n shit. So it's bush league code that causes it mostly? or server issues?

Samoan · 09-06-2003, 04:10 AM

A lot of times, it's the programmer's fault. It's easy to make mistakes when writing programs. One wrong character, and you're screwed.

wsjb78 · 09-06-2003, 05:05 AM

I tend to think most of the time the programmer just fucked up and did not optimize the queries if at all...

However high-traffic sites like this board use a lot of the mysql ressources and you can get errors like too many connections and stuff...

wsjb78

__________________
<br>Check backlinks of your sites
Get your Daily Google PR list here
ICQ: 171751720 <--> Wassup with lil2rich4u2 <--> Always looking for new Sponsors

com · 09-06-2003, 05:08 AM

Go with a good host, and you'll be running on a UNIX (hopefully FreeBSD) platform with MySQL built with compile time options that are made to optimise the database for your specific application. That and a careful eye and you won't have any problems with SQL.

-Brendan

09-06-2003, 01:41 AM	#1
theking Nice Kitty Industry Role: Join Date: Sep 2002 Location: The good old USA!!! Posts: 21,053	Question about SQL I have never used an SQL data base before...but I have seen literally hundreds of sites that have SQL errors. Can someone explain why this is. Is it the fault of the server...the programmer...or is SQL shaky? __________________ When you're running down my country hoss...you're walking on the fighting side of me! FOR THE LYING LOWLIFE POSTING AS PATHFINDER...https://gfy.com/fucking-around-and-pr...athfinder.html

09-06-2003, 02:27 AM	#3
LuSiD Confirmed User Join Date: Dec 2002 Location: South Florida Posts: 434	Some SQL errors, like "Too many connections," show up all too often, but these are always caused by poor configuration and/or programming. But databases aren't, in general, just "shaky", whether they are MySQL, PostgreSQL, SQL Server, Oracle, blah blah blah... and once you work out the issues you are having, they come in real handy! I live for dynamic content. __________________ I bought a dog the other day... I named him Stay. It's fun to call him... "Come here, Stay! Come here, Stay!" He went insane. Now he just ignores me and keeps typing.

09-06-2003, 02:31 AM	#4
Mutt Too lazy to set a custom title Industry Role: Join Date: Sep 2002 Posts: 34,431	i've always noticed the same thing with dynamic sites using mySQL, GFY included, lots of errors n shit. So it's bush league code that causes it mostly? or server issues? __________________ I moved my sites to Vacares Hosting. I've saved money, my hair is thicker, lost some weight too! Thanks Sly!

09-06-2003, 04:10 AM	#5
Samoan Confirmed User Join Date: Aug 2003 Location: Los Angeles, CA Posts: 203	A lot of times, it's the programmer's fault. It's easy to make mistakes when writing programs. One wrong character, and you're screwed. __________________ Samoan

09-06-2003, 05:08 AM	#7
com Confirmed User Join Date: Aug 2003 Location: Portland, Oregon Posts: 4,541	Go with a good host, and you'll be running on a UNIX (hopefully FreeBSD) platform with MySQL built with compile time options that are made to optimise the database for your specific application. That and a careful eye and you won't have any problems with SQL. -Brendan __________________ Real. Professional. Hosting. .:Expect Nothing Less:. 320-078-843 :: www.realprohosting.com :: [email protected]

09-06-2003, 05:05 AM	#6
wsjb78 Confirmed User Join Date: Jun 2002 Location: Cyberspace Posts: 594	I tend to think most of the time the programmer just fucked up and did not optimize the queries if at all... However high-traffic sites like this board use a lot of the mysql ressources and you can get errors like too many connections and stuff... wsjb78 __________________ <br>Check backlinks of your sites Get your Daily Google PR list here ICQ: 171751720 <--> Wassup with lil2rich4u2 <--> Always looking for new Sponsors