In addition, the optimization options are plenty to complete enterprise tasks and administrative commands.īusinesses in cloud data storage rely on MySQL for its fast capability that makes transactions smoother. PostgreSQL offers relational and non-relational solutions with high scalability when there are multiple operators. Anyway much thanks and very well done to all involved.The choice between PostgreSQL and MySQL depends on the needed scalability and reliability of data management functions. Also please rename - postgres is much neater than awkward postgresql - i can think of no good reason to keep. A nice looking gui client for pc / mac or a rich web client - ideally with an easy to install pre- configured integrated http server for table/view browsing + function calling - would be extremely welcome. Re pgadmin comment, no need to be abusive, but I have to agree to some extent, functionality is okish, but pgadmin is so ugly, therefore does unfortunately tarnish users impression of the wonderful db underneath. Also Postgres now seems to be accelerating it's rate of improvement, which is very exciting. At the time, I was blow away - by so much capability not in ms sql server, such as - surprisingly powerful native sql functions, domains, exclusion constraints, windows functions with aggregates plus enterprise features which cost a fortune with ms completely free. Postgres keeps on amazing me - I switched from sql server 3 years ago. I was shocked at how many things I suddenly could not do, things I had begun to take for granted. I had been working with it for about a month when I had to go back into Windows for a project. I downloaded Ubuntu and started using it. I had to buy a Windows laptop when I was working on the Windows port for PostgreSQL. It reminds me of when my son suggested I try Ubuntu Linux. But once professionals understand the design, they find it’s very intuitive and they’re hooked. So at first, for a database professional, working with PostgreSQL is a very different experience. But with PostgreSQL, there is a modular framework and all the features work with every other feature. Commercial products seek to package and productize features. It’s a database designed by engineers for engineers. There is a philosophical emphasis in PostgreSQL that is not present in commercial solutions. In presenting the content, I can highlight material that appeals to particular audiences.īut what longtime veterans find is a very different environment in PostgreSQL. In the beginning, I ask about their goals and their backgrounds so that going in, I know if I have a large group of beginners or a greater number of professionals with a background in DB2 or Oracle. TIP: I tailor my presentations to the students enrolled in that particular course. A beginner meanwhile can often pose questions that an experienced database professional never considered and they end up learning from the discussion. People with operational experience help beginners by providing insight into why someone would need to know or work with some part of the technology. Students from a mix of backgrounds provide a more interactive and enriching experience because of the questions they pose. In classes about PostgreSQL, it helps to combine veterans with newly minted database administrators. I also see whole departments within a company signing up because more enterprises are investing in PostgreSQL. I see experienced enterprise software professionals who are versed in operating systems and Windows, for example, taking the training to advance their careers. Knowing how to work with PostgreSQL has become recognized as a valuable career path for individuals. The professionals enrolling in training courses today come from a much broader technical background and the level of enthusiasm is much higher. The other population of students were serious technologists, die-hard open source devotees who wanted to use only open source solutions and were learning PostgreSQL because they needed a relational database for their operations.īut today, PostgreSQL is undergoing a renaissance of sorts as recent advances in features and capabilities have propelled the database forward with enterprises and small businesses alike worldwide. As a result, many of them tried to learn just enough to do what they needed to do. They had inherited a PostgreSQL database, for example. Many of the people who were learning how to work with it were doing so grudgingly because of some specific requirement. When I started teaching PostgreSQL education courses in 2001, PostgreSQL was the ugly one in the data center.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |