Best web database solution?
Hi
I am new to web development and I want to create a website which will rely heavily on database for retrival of information. I am thinking about learning how to create the database myself and linking it to my website.
I want the database engine to be easy to learn, secure, free if possible and have decent performance?
What is the best database solution currently available?
greg posted this at 02:58 — 31st July 2009.
He has: 1,581 posts
Joined: Nov 2005
What you use depends on what platform you are developing for (linux/MS).
As you mentioned "free" I'd advise MYSQL, communication would be PHP.
How "easy" to learn depends on your current skill and knowledge and ability to learn really.
There are plenty of beginner tutorials out there though.
w3schools.com and tizag.com are good for the basics.
You should consider reading about how to keep the DB (tables etc) as tight as possible, especially if the site's going to rely heavily on a database.
Generally speaking, a databases is the main cause for a site to be slow, especially if badly designed and accessed in a clumsy manner.
Small DBs generally don't cause much problem (unless really badly designed or used), but if the site is DB intensive and you have the time to learn then try to read about best practice and performance techniques for the particular scenario you will require.
PHP and MYSQL, although not perfect, are the most used combination, and certainly carry out task well enough for most website requirements, even large ones.
Jaime Magnus posted this at 20:31 — 2nd September 2009.
They have: 10 posts
Joined: Aug 2009
If you want it to be as you said “easy to learn, secure, free if possible and have decent performance” then it is surely MySQL. MySQL is free, easy to learn and implement, secure and mostly used because of its fast performance.
[Mod edit: promotional links removed]
Ari johnson posted this at 06:54 — 9th May 2013.
They have: 4 posts
Joined: May 2013
I prefer My SQL also as a best DataBase platform. Becuase it gives better security and fast retriving of your query.
Rightway Solution is India based most trusted WordPress development solution provider. It provides customize solution for Joomla template programming for thier international client.
luckygal posted this at 10:13 — 12th November 2009.
They have: 58 posts
Joined: Oct 2009
I think BizDB is a flexible and affordable Web database software with the ability to store, search and report thousands of records and images. The software is also powered by numerous add ons which can help you setting up your e-commerce database within a short period of time. In my opinion you can try this one.
kedwin posted this at 12:43 — 29th January 2010.
He has: 29 posts
Joined: Dec 2009
I am new to web development and I want to create a website which will rely heavily on database for retrival of information. I am thinking about learning how to create the database myself and linking it to my website.
I want the database engine to be easy to learn, secure, free if possible and have decent performance?
What is the best database solution currently available?
Hello wompier!
I understand your problem and for that use,
A LAMP environment is the best solution:
(L)inux (A)pache (M)ySQL (P)HP
Linux as the operating system, Apache as the web server, MySQL as the database and PHP as the language to create user interface with the db.Just go and do in this method.....
libbypetter posted this at 23:02 — 13th April 2011.
She has: 2 posts
Joined: Apr 2011
I think Microsoft SQL Server is one of the best web database solution. It provide extremely good service related to database. It also provide good security and feature. It can handle huge database. It is perfect for a web solution.
adarissmith posted this at 13:42 — 15th April 2011.
They have: 7 posts
Joined: Apr 2011
Today you are filled with ample of options that you can use, i will not like to drag the discussion as lots things have been made clear by my other counter parts but just want to say that Open Source is best Solution too all problems (SQL/My SQL/SQL Lite/ and enterprise solution Postger SQL)
jessicaellen posted this at 23:23 — 3rd May 2011.
They have: 31 posts
Joined: Nov 2010
I think everybody have given a lot of suggestions, but if you need a database specially for web so use open source Mysql, its the best one, easy to install, easy to maintain, easy to develop and the special feature of Mysql is that it is lite and also currently using by almost database developers.
SEO Mentor posted this at 17:07 — 1st November 2013.
They have: 1 posts
Joined: Nov 2013
For large database driven website development, first you need to learn T-SQL Queries and later on you can go for MySQL or MS SQL or Oracle database selection according to your database requirements.
Domain Registration India - Web Hosting India - Web Hosting Delhi
Dekotlen posted this at 15:57 — 24th January 2014.
They have: 17 posts
Joined: May 2013
MySql for web solutions, SQL lite it's also very simple but better for mobile app solutions.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.