Jump to content

[SOLVED] PHP And Databasing


phrozenflame

Recommended Posts

I have learnt a few new things about databasing but I had some questions.
I have heard at www.w3schools.com that ms access was a database that should only used for small type databases, I have though talked to a few sql exprts, and they said they use data for everything, even huge massive databases with thousands and thousands of entrys.  If there is a reason to not use msaccess for major databases what would those reasons be.  And if I need another program for major databases, what is a good database program, that I can use that supports mysql, dbqwik, postgresql, and others as well, that is a best database program that is fairly easy to use, and can be used for all purposes big and small.  I sort of want something that can work with all forms of database I want to use mysql with php, but I still want to know dbqwik, postgresql, and the other's out there in case if a client needs something done, or wants somethng done with a specific database type, or incase if the server I am working on, only supports a certain type
Link to comment
https://forums.phpfreaks.com/topic/32329-solved-php-and-databasing/
Share on other sites

MS access should only be used for small systems. It's also not really meant to be run on the web (concurrent users) and can act funky sometimes. The biggest reason to NOT use it is b/c of its lack of security and efficient processing for large amounts of data.

Not really sure what you mean by database program.... the things you mentioned are Database Management Systems nnot really a collective program that supports those thinngs. MySQL is a decent database system and integrates very nicely with PHP. There are tools to help administor it (phpMyAdmin, MySQL Query Browser, MySQL Administrator). It's available under GNU license (or some flavor of it) which makes it basically free and its very scalable, efficient, pretty secure and has a large support following. MS SQL Server is decent if you are willing to pay the cash. I don't personally have much experience with PostgreSQL but I know people who swear by it.

Guess I'm not totally sure what you're asking but my advice is to start with MySQL and then pick up the others as necessary.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.