• Quick note - the problem with Youtube videos not embedding on the forum appears to have been fixed, thanks to ZiprHead. If you do still see problems let me know.

Need A More Robust Database

Iconoclast said:
My post above in which I stated that I was under the impression that MySQL had developed into a nice product was based on the assumption that it now supports stored procs and triggers, and I'm pretty sure such features have been available since a release six months ago or thereabouts.
Click to expand...

No, it's more recent than that. They started supporting some stored procedures with Mysql 4, but it was half-assed support.

MySql 5 ostensibly has full stored procedures, functions, triggers, etc. It was first released in March, and is still only in development (i.e., beta) release.


I consider stored procedures critical for any public facing database, allowing the user to fire an immediate SQL query at a database is a real security issue. If the public user account has stored procedure permissions but not immediate SQL permissions you can much more easily control just what data the user can view and modify, you don't need to reparse the queries coming in to check for possible nefarious intent. Plus you get a nice performance boost.
Click to expand...

No argument here; I'm a web app developer. In-line SQL queries = bad thing.
 
Wudang said:
Well the industry leaders are DB/2 and Oracle. Both allow free downloads for evaluation and have different prices for different editions. The DBAs I work with all reckon SQL Server sucks compared to DB/2, Oracle, Sybase et al.
Click to expand...

I would agree, though I'm not a big Sybase fan.

DB2's a pretty solid product, as is (for the most part) Oracle. But these are incredibly pricey for any professional deployment.

The nice thing about MySQL and PostgreSQL is the price tag. $0.00.
 
Cleon said:
MySql 5 ostensibly has full stored procedures, functions, triggers, etc. It was first released in March, and is still only in development (i.e., beta) release.
Click to expand...
Thanks Cleon. I'm currently in the process of building a code generator, and had planned to include support for SQL Server, Oracle, and MySQL. It looks like I'll need to await a little longer before I can target MySQL.
 
Iconoclast said:
Well, now you're talking about a different league. I don't think Yahweh would be interested in coughing up the $5000 odd to buy the entry level Oracle product, and I believe the cheapest DB2 offerings are more expensive again. This thread is in relation to free or inexpensive databases, so neither of those products fits the bill.
Click to expand...

At the risk of being boring, (Ok, I'm already boring), Maxdb is rated for SAP, and FREE, and has those thingys that seem to be important for a real production environment.

Adabas (the previous name for MaxDB), was regarded more highly than Oracle in the mainframe world. Oracle was rumoured to be about to fold for a while there, because it's performance was woeful, while Adabas already ran industrial transaction rates. Oracle got lucky when Unix came along, (in the commercially acceptable sense), and was an American product rather than a German one, (An important consideration back then).
 
Cleon said:
I would agree, though I'm not a big Sybase fan.

DB2's a pretty solid product, as is (for the most part) Oracle. But these are incredibly pricey for any professional deployment.

The nice thing about MySQL and PostgreSQL is the price tag. $0.00.
Click to expand...

Yeah, the edition I was thinking of is for development only.
 
Originally posted by Wudang The DBAs I work with all reckon SQL Server sucks compared to DB/2, Oracle, Sybase et al.
Click to expand...
It's true that SQL Server won't scale as large as Oracle and DB2. Other than this (important!) consideration, I don't buy the notion that SQL Server sucks in comparison.
 
I've been to the websites of the above mentioned products, however the websites are very very user unfriendly - I really have no idea what I'm downloading. So far, I've downloaded several files that dont seem to do anything but sit on my desktop and say "Error" when I try to install them, or source code files that I cannot compile.

I'd like to try PostGreSQL or MaxDB database, but I dont know which links to click. Could someone copy and paste the URL to an installation file (suitable for Win98) for one of these products.

I know, I'm a total n00b.
 
varwoche said:
It's true that SQL Server won't scale as large as Oracle and DB2. Other than this (important!) consideration, I don't buy the notion that SQL Server sucks in comparison.
Click to expand...
Incidentally, I'm working with a multi terrabyte sql server database as we type.
 
Yahweh said:
I've been to the websites of the above mentioned products, however the websites are very very user unfriendly - I really have no idea what I'm downloading. So far, I've downloaded several files that dont seem to do anything but sit on my desktop and say "Error" when I try to install them, or source code files that I cannot compile.

I'd like to try PostGreSQL or MaxDB database, but I dont know which links to click. Could someone copy and paste the URL to an installation file (suitable for Win98) for one of these products.

I know, I'm a total n00b.
Click to expand...
Check this out. It should be a good starting point.
 
PogoPedant said:
Check this out. It should be a good starting point.
Click to expand...
Thanks :)

But the installation file I've downloaded shows the error "Failure to create process 2!", then closes - no worries, hopefully I can find another good database.


Originally posted by wahrheit
I've been working with MySQL databases (and PHP) on quite a number of high-traffic sites, it never failed.
Click to expand...
Periodically between the times of 12 noon and 3 pm (Yahweh Standard Time), the forum software gives me a "too many users connected error".
 
Doesn't JREF use MySQL? Don't know if that qualifies as high-traffic or not.
 
BPSCG said:
Doesn't JREF use MySQL? Don't know if that qualifies as high-traffic or not.
Click to expand...


Not really. the site has an alexa rank of 33,117.
 
BPSCG said:
Doesn't JREF use MySQL? Don't know if that qualifies as high-traffic or not.
Click to expand...
It uses MySQL and PHP.

Right now, the website has 200 users connected (its 12:20 PM YST), and I can already feel the server begin to bend at the knees.
 
Buckling with only 200 users? Got any more details? I dunno about you guys but I still find a use for the old flat-file every now & again.
 
You must log in or register to reply here.

Back
Top Bottom