Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
I am planning a new sql server for my office, I am currently using Mysql. My question (since this is linux questions) is which does everyone feel is better, MySQL or Postgre? I have read quite a bit on this, but I'd like to hear is from a bunch of real lifers. Anyone? Don't hesitate to post or ask for more info.
I started with PostgreSQL and I have never had a reason to switch. I have one server with MySQL and PostgreSQL both running so I can play with them. It is really a comfort thing as to what you are used to. Both are very capable and free but when I search for tools or look at DB applications, there seem to be more that are set up for MySQL.
No matter which one (or both) you run, I recommend PHPMyAdmin and PHPPgAdmim as the best GUI interfaces I have found.
postgresql is FAR superior when it comes to mission critical data (row level locking etc). mysql just doesnt have the data integrity that you can count on.
mysql is good if you dont need a lot of locking and one users changes data at a time. like a small site with one admin and many readers.
i use mysql and sybase (costs money) in production. I have not used postgresql in production but if I were to switch the site that uses sybase, I could not use mysql I would have to go with postgresql.
After looking at this for a long time and wondering why people use mysql over postgresql. I believe it's because mysql has a bigger install base. If postgresql was the default DB your hosting provider offered, no one would complain.
I think it all really depends on what you need to do, the scale, the reliablity and such. I started with MySQL as a backend for applications, but ran into several walls trying to do complex queries that involved sub-selects. That's why I initially looked at PostgreSQL and I've never looked back.
I'm not sure if you know who Randall Scwartz is or not, but he's a well-respected author on Perl and in an article in Linux Magazine, he says that PostgreSQL is an open-source alternative to Oracle, as far as scalability, stability and features are concerned. And quite frankly, I agree with that.
Thanks guys, that is what I wanted to hear. I have looked as I said I have looked at a lot of comparisons, and think postgre could be a nice setup. I'll try it, but still keep that mysql ready as a backup. Thanks agian. Anyone else?
I think that the people behind mysql would give an argument for every statement mentioned that would superiorize PostgreSQL . I think its all propaganda, I believe they are both great DB's but I would personally go with MYSQL because of the, (what I believe at least) better support, and tools. Not to say anything bad about Postgre tho.... they're both awesome.
I do think the folks behind mysql would argue about its mass database capability. They'd point to the many large billion dollar corps using mysql as their database solution. mysql has come along way since its inception into the business world.