mudia icon mudia.com

Mudia Web Developer Databases

database

SQL: oh query my query

Developing databases with PostgreSQL is terrific because everything works so well.

The psql is most useful.

And, when a web-browser interface is need the phpPgAdmin (perhaps found on your cPanel) gets the job done effectively.

Learning SQL is a good investment because (1) versatile, as it works with DB management tools from different vendors and (2) stable, as it does not seem to have changed much others years.

The command-line program pg_dump is useful to backup databases. Although, the other day, a perl script was able to read the database and output custom-made INSERT statements.


Database Management System

postgresql

PostgreSQL is "is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance."



See Also

freeradiantbunny docs

Database Schema Management Systems

To study the practical database knowledge, we use the learning tool "database for freeradiantbunny".