Enterprise Database
- Thread starter Macaodha2009
- Start date
Upvote
0
I am assuming he means one which conforms with the SQL standards to a decent degree and can cope with a significant number of simultaneous users.
Personally I'd go for PostgreSQL if I were you. Far better programming platform than MySQL due to its closer adherence to SQL standards. Although having said that MySQL has got considerably better in recent years with its standards compliance.
Upvote
0
PostgreSQL it is a smooth database.
MySQL is more for those wanting to switch engines, but of course a lot of ISPs bundle it so people who have taught themselves from an ISP account tend to use it.
MySQL use to be the posterboy for opensource databases, but that was because PostgreSQL was less well known back in the day, primarily because it is older in the world of opensource being closer involved to BSD, and didn't get the shiny new Linux look'in that MySQL got.
PostgreSQL is just rock solid, excellent online help both on the web and in psql, and as someone has already mentioned it does adhere to the SQL standards more than any other RDBMS. I prefer PostgreSQL to Oracle and Sybase, far more flexible. As far as functions goes you are offered a number of different systems; PL/Python, PL/Perl, PL/PGSQL, PL/TCL. Personally I prefer plgsql, but if you are au fait with another language you can use that.
MySQL is more for those wanting to switch engines, but of course a lot of ISPs bundle it so people who have taught themselves from an ISP account tend to use it.
MySQL use to be the posterboy for opensource databases, but that was because PostgreSQL was less well known back in the day, primarily because it is older in the world of opensource being closer involved to BSD, and didn't get the shiny new Linux look'in that MySQL got.
PostgreSQL is just rock solid, excellent online help both on the web and in psql, and as someone has already mentioned it does adhere to the SQL standards more than any other RDBMS. I prefer PostgreSQL to Oracle and Sybase, far more flexible. As far as functions goes you are offered a number of different systems; PL/Python, PL/Perl, PL/PGSQL, PL/TCL. Personally I prefer plgsql, but if you are au fait with another language you can use that.
Upvote
0
Upvote
0
Latest Articles
-
MTD for Income Tax: your first quarterly update is due 7 August.If you are a sole trader or landlord and your gross income from self-employment and property was...- maka
- Updated:
- 4 min read
-
Andy Burnham's Manifesto for Small Business, and How It Stacks Up Against Count BinfaceIf all goes to plan (or rather, to Labour's timetable), Andy Burnham will be sworn in as Prime...- Ozzy
- Updated:
- 5 min read
-
SEO in the Age of AI: What UK Small Businesses Actually Need to KnowTL;DR Search has shifted from "ten blue links" to answer engines, and the click is dying...
- Ozzy
- Updated:
- 11 min read
-
What Carphone Warehouse, Microsoft and Uber Have in Common: They Started in a DownturnThere's a comforting myth that you need a booming economy to start something. Cheap money...
- Ozzy
- Updated:
- 3 min read
-
What Makes a Small Business Actually Sellable?There's a question that a lot of small business owners never think to ask until they absolutely...
- Ozzy
- Updated:
- 5 min read