phrozenflame Posted December 31, 2006 Share Posted December 31, 2006 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 More sharing options...
dbo Posted December 31, 2006 Share Posted December 31, 2006 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. Link to comment https://forums.phpfreaks.com/topic/32329-solved-php-and-databasing/#findComment-150132 Share on other sites More sharing options...
phrozenflame Posted December 31, 2006 Author Share Posted December 31, 2006 Thank you Link to comment https://forums.phpfreaks.com/topic/32329-solved-php-and-databasing/#findComment-150133 Share on other sites More sharing options...
matto Posted December 31, 2006 Share Posted December 31, 2006 PostgreSQL offers (and has for sometime now) features that weren't available in earlier versions of MySQL like triggers and stored procs etc which have only recently been introduced into MySQL 5.x. Both PostgreSQL and MySQL are a great choice for using with PHP. :) Link to comment https://forums.phpfreaks.com/topic/32329-solved-php-and-databasing/#findComment-150135 Share on other sites More sharing options...
phrozenflame Posted December 31, 2006 Author Share Posted December 31, 2006 Thanks Matto Link to comment https://forums.phpfreaks.com/topic/32329-solved-php-and-databasing/#findComment-150142 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.