avell
Nov 24 2007, 09:55 AM
| | Hey Everyone!,
Please choose your preferred database s/w!
Regards,
Avell |
Reply
yordan
Nov 24 2007, 08:33 PM
You are comparing two free softwares toward a very expensive professional one, they are not really comparable.
Reply
psql
Jan 14 2008, 10:43 PM
Depends on what your current environment is where you are coming from and where you want to go. They are all robust capable databases but obviously even with support contracts PostgreSQL and MYSQL are a lot cheaper than Oracle to roll out. PostgreSQL is more enterprise capable (read highly robust reliable and scaleable) than MYSQL . Things like Skype runs on PostgreSQL and thats a big system. MySQL is pretty much installed on every webserver out there and ideal for those kind of apps. Perhaps skills are more generally available for mySQL but with PostgreSQL 8 thats changing. One of the issues most important and most ignored is normally what experience do you have in house and where are you starting from. Probably the biggest issue with the adoption of open source solutions in a company is migration of applications, data and skills from Oracle to either of the above open source products. Once you start assigning value to risk ond time and people an experienced Oracle DBA or Oracle salesman can start making open source seem very expensive to a CFO. If you are moving from Oracle there are options like PostgreSQL based EnterpriseDB which offer Oracle compatibility with PostgreSQL reliability and performance and allows lots of money saved and an easy entry into the open source space for an Oracle shop. If you are starting from scratch with nothing invested in skills or technologies today i'd go with PostgreSQL
Reply
xboxrulz
Jan 15 2008, 01:56 AM
I prefer PostgreSQL because it's faster and more stable since most people are on MySQL and if it is running a crazy script, then it pulls the whole system down. xboxrulz
Reply
Sten
Jan 15 2008, 02:44 AM
the only one ive ever used is mysql and im happy with it. im not that brilliant with that kind of stuff so mysql will do and post things like a cms and a forum are for mysql. i made the poll a tie! lol.
Reply
cmsnoob
Jan 22 2008, 05:10 PM
i have no idea what the difference is between these guys but i would like to find out, can u help? 
Reply
yordan
Jan 23 2008, 03:29 PM
QUOTE(cmsnoob @ Jan 22 2008, 06:10 PM)  i have no idea what the difference is between these guys but i would like to find out, can u help? Read the psql answer, a few lines upwards in the present post, you will already have a good idea of the difference. Also my answer gives the basic options.
Reply
divinity
Mar 3 2008, 09:59 PM
I like mySQL just because i have been using it for a long time, and it is easy for me to understand. Mysql ftw.
Reply
Miles
Mar 4 2008, 08:57 PM
I use mySQL and always have, therefor it is my preference, also in it's favour is that it's free, is used by nearly all PHP and a lot of ASP(.net) web scripts, is well supported, is easy to use, and is included with nearly all hosts. I also like SQLite, and postgreSQL seems interesting, if it is free I shall have a try of it, it sounds interesting, and there seems to be a positive opinion of it within this thread, best of all it's included with astahost so I can try it easily.
Reply
Darasen
Apr 7 2008, 04:05 PM
I had to put in a vote for Oracle. lt really does depend on scale though. But, if you want to manage millions upon millions of entries you want Oracle. Look at this list of limitation for example. For simple things like Forums or the like MySQl is sufficient.
Reply
Similar Topics
Keywords : oracle, mysql, postgresql, poll, choses, preferred, db, s, w
- What You Need Before You Can Create A Text-based Game..
Using PHP, HTML and MySQL (5)
Mysql Multiple Tables
(1) It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed
that I selected all of the rows in the table. Normally you will try to not select the entire table
from the database unless you absolutely want all of the table. I would recommend against....
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
How To: Display A Members/user List.
With PHP, Mysql, and HTML. (3) Alright, some of you might want to display your User's or Members on your site. Notes: 1.This
is to fit in with Feelay's register and Log-in scripts you can find in the tutorial section. 2.I
made this to show the members of my site who is a member and what their ID is. First off, we must
set up a connection to our MySQL Database. CODE <?php $con =
mysql_connect("localhost","database_username","database_username_password
4;); if (!$con) { die('Could not connect: ' .
mysql_error(....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
Can You Link Game Maker With Mysql/php
Title says it :D (0) Hello, I am new to this service and i think I am going to like it =). Anyway, my main question is
can you link executable games made by gamemaker (i have pro) to a database? And can i use the php
server i get here to transfer data to that game? If so i would appreciate a little help with it
because I am new to both =). Also is there anyway to get a www.mywebsite.com via credits from
astahost? Finally is there any group here that works with gamemaker? we might have small contests
or so /tongue.gif" style="vertical-align:middle" emoid=":P" border="0" alt="tongue.gif" /....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE
(Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed
database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST.
Consider that BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20.....
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
Mysql With My Own Server
few questions (4) Hi, I've only just joined the forum Can you link the mysql database here to your own website?
If so how would I go about it Thanks =D....
Mysql Storage Engine Error 28
(5) Hello, On my website and forum, SDeckNET, the mySQL database is not working. I get the error "mySQL
error: Got error 28 from storage engine mySQL error code: Date: Wednesday 02nd 2008f July 2008
05:33:53 AM" from my forum. From what I know, error 28 means I'm out of disk space, how can this
be? I was never told of a mySQL space limitation and all these cases of downtime are destroying my
site's memberbase. EDIT: It now seems PhpMyAdmin is down too, with the error: "Warning:
session_write_close() : SQLite: session write query failed: database is full in /usr/l....
Php And Mysql Extension Installation
(0) /** * $Author: pgeric $ * $Revision: 8 $ * $Date: 2008-06-30
19:40:52 +0800 (Mon, 30 Jun 2008) $ * $Id: php_mysql_install.txt 8 2008-06-30 11:40:52Z
pgeric $ */ Installing newer version of php and enable mysql connection. (As of this writing
will be targeted at php 5.2.5 and above) Because of a change on newer version of php. Some files
have been moved around within the default folder structure of php package. The result was when try
working with mysql. It surprise you a lot. (The dicussion on this was based-on zip....
I Have An Error With My Mysql Connection
mysql connection error (7) ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
connect to the my sql server...i followed this guide
http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
login info i always get the error cannot connect to the database here is my config.php if you can
help me CODE <?php $host['naam'] =
'CENSORED'; // my host $host['gebruikersnaam'] =
'righto'; // my database username $host['wach....
JDBC With Postgresql
Can't find org.postgresql.Driver?? (2) So recently I have been trying to connect a PostgreSQL database that I have set up on my local
Windows Vista machine (yes, Windows machine, I know it's horrible for servers; still working on
getting the darn thing to work on my MacOS X on my laptop). So I initialized the service, and now
it's running. However, the problem is that I tried to connect the database using the code below
I found on the website where the @author is now. Obviously I had to edit the code so it would work
and connect to my server and database. CODE /* * To change this template, choos....
Mysql - So Hard
Come in here if you think MySQL is soo hard! (14) Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
databases just for one little script and you have to type things in like ;Host-Username:
(blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
random, and it is alot harder than that. If you have expierenced it being hard, you are free to
post right in here, mate.....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect:
' . mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person
(username, password) VALUES ('$_POST ','$_POST ')";if
(!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record
added";mysql_close....
Rating On Habbo? (poll)
(18) Hey all, Well i would do 3 because it isn't that good but its ok you have to pay bad graffics,
/dry.gif" style="vertical-align:middle" emoid=" The only good thing about it is that you can speak
lol. /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />....
Oracle 10g Install Issues
(27) So I'm trying to install 10g on my XP Pro development box, and the install goes fine (I do the
basic install of enterprise edition, I'm by no means an oracle expert) and when it gets to the
part where it wants to create a database, the database creation assistant fails saying first that it
cannot retrieve credentials, and then that it can't connect to ORACLE (I'm assuming this is
the instance name). Anyone have *any* idea what's going on here?....
Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom)
150 MB space, 10000 MB Bandwidth, php, mysql, CPanel (10) Hello Members, We are proud to introduce a new member to Xisto group of sites.
Qupis : Free Web Hosting 150 MB space, 5000 MB Bandwidth, php,
mysql, CPanel (Latest). Emails, FTP, Addon domains, Parked Domains etc.
http://www.Qupis.com
Feel free to add your reviews and comments about it. -AstaHost
Management ....
Navcat For MySQL
is Navcat any good? (8) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
PHP & MySQL: Displaying Content From A Given ID
(6) Okay so I got this sample link (not working): http://www.acosta.com/joo.asp?id=654 Now suppose
I have a PHP file that would use MySql in order to get all values in the row where id 654 is found.
Here's a sample DB: Table: demnyc ______________________________________ | id |
Name | Age | Email | *----------------------------------------------------* | 1
| Albert | 17 | no email |
*----------------------------------------------------* | 2 | YaPow | 888 |
no email | |__________....
MySQL, Multiple Tables
(24) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
MySQL Output Database Question
(18) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
VBA And Oracle
(8) Hello everyone, I need to connect directly my Excel VBA macro to Oracle DB using ODBC. I can do it
by creating a query table and when executed, copying required data from the worksheet, where they
have been loaded, to an array in memory. I would like to know a easiest and more efficient way to do
it. In the manual there is no functionable info about odbc connections. Thanks....
My Review Of Runescape... What's Yours ( Poll ) ?
My Review (66) I like runescape and all but they have terrible graphics , customer support , lag , and moderation.
I did a little test i said 3 swear words and i was banned. I advertised a scam site for 2 and a half
hours and did not get banned, bad moderation huh? yes its terrible. Why don't they
upgrade there server or like make some new worlds i mean like 2000 people in one world is insane
lower it to 1000 jagex (very lazy). There is so much lag on runescape it is not even funny. I
don't think runescape is the best game on the net there are hundreds of way better....
[PHP + MySQL] Encrypting Data
To protect the password of your DB, for example. (9) Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the
MySQL DB. Here we go! ------------------------------------------------------------------------
CODE <?php $password = "abc"; $new_password = md5($password);
echo $new_password; ?> The password "abc" was codfied using md5() This will be:
900150983cd24fb0d6963f7d28e17f72 CODE <?php $normal_pass = "abc";
$encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($norm....
Need Help With A PHP - MySQL Registration Script
Wont INSERT into the database (13) hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE CODE
<?php # register1.php # common include file to MySQL include("DB.PHP");
$Username=$_POST['Username'];
$Password=$_POST['Password'];
$Name=$_POST['Name']; $Last=$_POST['Last'];
$Sex=$_POST['Sex']; $Month=$_POST['Month'];
$Day=$_POST['Day']; $Year=$_POST['Year&....
Mirror My MySQL Database To Another Mysql Server
(4) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Recover Tables From A MySQL .frm File
(8) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for oracle, mysql, postgresql, poll, choses, preferred, db, s, w
|
|
Searching Video's for oracle, mysql, postgresql, poll, choses, preferred, db, s, w
|
advertisement
|
|
