Database programming with MySQL
All bigger sites on the web are database driven. A database is nothing more than a bunch of files which are structured to hold and manage a lot of data. The most successful standard for databases was “relational”, which means the data was kept in tables with references (relations) to each other and SQL, the “standard query language”, was used to work on these structures.
Time is running by and some people swear the best format would be XML to store the data. IMHO is that format a bit down the road and if you want to build your site on a database today, your best choices are:
- MySQL
- PostgreSQL
- or the bigger ones like Oracle or DB2
I have been working with MySQL for quite some time now and I like the software (mostly because I am used to it, I guess).
Tradebit runs on a typical LAMP installation: Linux, Apache, MySQL and PHP.
Nearly EVERY hosting company with solid offers includes a MySQL database with your hosting package.
(0)
September 19th, 2006 at 9:12 am
hello there,
i am trying to reproduce a data server that a company uses to present information to its customers via the web. No problem. What they are using right now is Microsoft Access, connecting via ODBC to a server on line. The cool thing that they can do is have several tables linked together. Like if a certain field is updated in one table, it updates the same info automatically in another table. So, i want to reproduce this in MySQL, but i can’t seem to find out how. Is there a way to pull this off on the server side ? or does that have to be done on the client side ?
thanks for any tips.
September 19th, 2006 at 9:21 am
hi jeff, MYSQL5 is capable of VIEWS, this, what you want!
look in the MySQL documentation on http://www.mysql.com for “Create View”.