Best web database solution?

They have: 1 posts

Joined: Jul 2009

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's picture

He has: 1,573 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.

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's picture

They have: 4 posts

Joined: May 2013

Jaime Magnus wrote:
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.

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.

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's picture

He has: 29 posts

Joined: Dec 2009

CountWompier wrote:
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?

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.....

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.

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's picture

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.

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.

They have: 18 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.