Posted 18 March 2012 - 12:31 AM
I'm a bit late to the database scene. Until now, I've been using flat files, out of ease, but I really need to use something more efficient, if I'm going to develop applications people will want to use. And because I'm developing free software, I need free databases. I also need it to run in non-Windows environments.
I've done some research, and PHP supports many types of database software, including several flavors of SQL, which seems to be the most popular. But I'd hate to start working with one, just to need to switch later.
What would you recommend, and why?
Posted 18 March 2012 - 12:48 AM
start with http://php.net/mysqli
or more for more compatible databse handling http://php.net/pdo
IDE: Netbeans 7.3 on Twilight theme (php) , Eclipse(java)
Debugger: Xdebug, Cachgrind
stop using mysql extension it is obsolete now. use mysqli instead or more better PDO for secure ,efficient database handle
Posted 18 March 2012 - 08:59 AM
ADODB for instance, has a system that makes your code work in all kinds of database platforms.
But if you want a recommendation for a web database, most websites use MySQL. I'd recommend it. It is simple and comes with home webserver packages like wamp or xampp.
Recommended code editor for beginners: Notepad++ (supports coloring for many many coding languages)
Recommended PHP editor for advanced coders: phpDesigner
Recommended editor for advanced website designers: Dreamweaver
Favorite browser: Mozilla Firefox
Posted 18 March 2012 - 10:42 PM
One last question. I downloaded the latest version from the MySQL website, and tried to install it using these directions: http://0gb.us/?mysql
But when I got to the configure line ("./configure --prefix=/usr/local/mysql"), I got an error. about no such file existing. I've never had ./configure fail before. Any ideas?
Posted 22 March 2012 - 05:14 PM
"Complex problems often have the simplest solutions" -- Not sure who said that first.
=== My projects (all feedback welcomed) ===
XML_XSLT2Processor(0.5.3) - perform XSLT 2.0 transformations in PHP.
PEAR2_Net_Transmitter(1.0.0a4) - reliable sockets.
PEAR2_Cache_SHM(0.1.2) - persistent data storage wrapper.
=== Useful tools ===
NetBeans - full featured PHP IDE, as well as a decent code editor for other things.
Fiddler2 - The best free HTTP debugger. Performance tuning, security check, integrity check, custom requests and more, all made easy.
Gobby - That's NOT my Nickname! Look at the topic.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users