what database type do u favorably use?

parawizard

I use MS access data base and a ODBC connection to it

wut do u use?

Weedpacket

I certainly do not use MS Access. It is nowhere near robust enough for a web environment.

LordShryku

Agreed. Of course, my web enviroments almost never even run Windows, and if they do, they aren't running any Office warez. I answered "other" because my main databases run from Oracle. But I also use MSSQL, MySQL, and PostgreSQL on various other projects. I don't like being tied down to any one database just as much as I don't like be tied down to any one programming language.

Moonglobe

i answered mysql cuz that's all ive worked with....... but i do hope to get pgsql up soon 🙂

drawmack

I've written web apps that use the following databases

mysql
postgre
ms sql server
access
oracle
sybase

the decision about what database to use comes down to the following, in order:

1) what is available on the server?
2) does the client have a technology of choice/what technology do they already have in place?
3) IMO which database is best suited to the task at hand?
4) how will the amount of my quote be affected by the technology?

parawizard

i work with ms access because i have my own server setup at home

im sorta familiar with mysql its not too hard to use different ddatabases 🙂

im making a form with ms access i guess when i release ill have a mysql version also

but i dont think you need acutal ms access to use tht data base

you connect with odbc i think ms sql works to.

srry about my typing but im going one handed im holding ice pack to my mouth because i just got all my wisdom teeth out and srry i meant to post this in th discussion forum

LordShryku

Well, you can use Access with ODBC to connect to most DB types, but when working with building applications, you'll find the need to use more powerul SQL then Access can handle. Moreover, a powerful database consists of more than just tables. The need for triggers, stored procedures, etc come into play.

Merve

I use MySQL. I haven't tried anything else. I'm not very adventurous. I have Access installed on the computer, yet I've never even used it, well I guess other people in the family use it...weird eh?

pyro

I've only ever used MySQL. I'd like to play with PostgreSQL one day, though...

Danicek

Currently working with Sybase ASE.
Experiences with many db "out there".

I do not think there is best db, it depends on what you want.
However Oracle seems very robust to me and Sybase very nice in querying it. MySQL on other hand is very cheap and in small databases very fast.

piersk

Oracle is good if you can afford it. I'd go as far to say that it's probably the best out there.

MySQL certainly should be cheap. It's free (under certain licences) 😃

Although I've created web apps using ASP and Access, I am trying to move away. SQL server is so much faster, but its a bit of a hassle to set up a db every time I wanna do a small site, so I use Access. I would (personally) never use Access with PHP.

I've never used XML for a db. I guess it's just cos I don't know enough about it and nothing has come up where its necessary atm.

For choice, it would have to be MySQL every time.

Danicek

I think that for very small amount of data (such as several usernames and passwords) it is good to simply use txt flat file.
Everytime someone is trying to set up a db for his web site when he/she will use it just for 6 or 10 entries, I think about good old flat files >).

Dr_Freak2

At school,they teach Micro$oft's software.e.g.VB.NET,Access...However,I would like to try out something which is open source,free and robust.So,I've chose MySQL database.As most of the people said,Access is not good enough for something much more complicated usage.If you use ODBC to connect the database,I think the speed is much more slower.That's not efficient enough if you develop a web application. 😉

What do you think?

piersk

I read somewhere that even when using MyODBC (which I think is some sort of emulator) to connect to a MySQL db (even when on another server), its faster than just using a normal ODBC connection to connect to an Access database on the same server.

GilesGuthrie

I use MySQL. I've had a lot of bad experiences with Access.

When I first started using MySQL I thought it would be cool to try to create a MyODBC connection to it, but I couldn't get it to work. My host said they didn't support it anyway and recommended I use phpMyAdmin. I humphed for about three seconds and haven't looked back.

Weedpacket

My experiences it has to be admitted date from the late 1990s. It was a big project that was expected to have ≈2000 users; it fell over and died with twelve - too many concurrent db connections.

The only reason it can be used at all is a side-effect of supporting ODBC.

Merve

rofl weed, all too true for M$ projects...can MySQL support that many connections?

I've never used Access...ever...I have no idea how to use it and I don't plan on learning how. My sister had to learn visual basic just to use advanced searching functions on the DB...what a piece of crap! Stop using Access, parawizard, and switch to a real DB...it's for your own good. 🙂

Shrike

MySQL, .csv, .txt 🙂

The DBA on my last project reckoned that Access was fine for the web end, but I used mySQL anyway. Access is synched to the web db for some admin tasks I think. Apparently it's not as bad as it used to be 🙂

AstroTeg

Access was made for home use, not the abuse a web app might give it (granted, its gotten better). I've seen Access fail horribly (and it was usually daily if not twice a day) for 25 users.

MySQL is fun to play with. Postgres seems to have more features then MySQL from my reading, but I haven't had a chance to fully play with it yet. I've done sites with MS SQL and Oracle as well (for those times when you need industrial strength).

piersk

To give credit where credit is due, at work we have an access db for a document library. There are about 600 users and about 450 who use it on a regular basis, and it's never gone down on me. Bear in mind that this is when using ASP rather than PHP.