I have heard good things discussed for the past few years about using ccache to speed compiles of Postgres. I finally got time to test it and saw my Postgres compile times drop from three minutes to one minute. Supposedly ccache always produces the same result as a normal compile (including any compiler warnings), so I plan to use it from now on.
Ccache UsageArchive for August 2009
JPUG Tenth Anniversary
Thursday, August 20th, 2009 by Bruce MomjianI realize it is a month late, but I want to say how happy I am that the Japan PostgreSQL Users Group (JPUG) is celebrating ten years of activity. I have been privileged to have been involved in more JPUG activities than most non-Japanese. The size and accomplishments of JPUG far exceed that of any other Postgres user group, and the JPUG has enabled much of the advanced research and wide-spread adoption of Postgres in Japan today.
The big JPUG event this year is their tenth anniversary conference. I plan on attending and I know many international Postgres developers are planning to attend as well.
JPUG Tenth AnniversarySQL Injection
Thursday, August 20th, 2009 by Jim MlodgenskiOver the last week, the big news in the IT world that crosses over to the mainstream media is the recent ID theft case. It does not surprise me that the group was able to steal so many credit card numbers, but it does surprise me how they accomplished it. They used a SQL injection attack to plant sniffers inside corporate networks. The surprising part is that these types of attacks are preventable with good defensive programming. Simply validating the input fields passed to the backend database is a good start. Or, how about using prepared statements or stored procedures on the database that force some validation. This will not be the last time that we hear of such an attack as long as developers are not thinking like a hacker when creating their web apps.
SQL InjectionAre Oracle Price Increases Affecting Your Budget?
Monday, August 3rd, 2009 by EnterpriseDBToday EnterpriseDB introduced a program to show you just how easy it is to migrate from Oracle to Postgres Plus Advanced Server AND save a considerable amount of money at the same time.
Companies such as Sony Online Entertainment and FTD have already enjoyed considerable savings by migrating from Oracle to Postgres Plus Advanced Server using our Oracle compatibility technology. In fact, the technology is so reputable that IBM recently licensed it for use in DB2.
We created the Oracle Migration Assessment Program after Oracle recently raised prices on database modules by as much as 40 percent. This comes on the heels of license increases of up to 20 percent in 2008. An Oracle Migration Assessment report from EnterpriseDB scans, analyzes, categorizes, details, and scores the work necessary to move your Oracle database to the open source based, Oracle compatible, and reasonably priced Postgres Plus Advanced Server.
The program enables enterprises to migrate their applications running on Oracle to Postgres Plus Advanced Server, a PostgreSQL-based database containing an Oracle compatibility layer, with no disruption to operations, and delivers ongoing cost savings of 80 percent or more.
Your Oracle Migration Assessment is performed by an experienced Oracle engineer who will work with your staff to provide you an accurate and reliable report on the viability of migrating your Oracle database complete with time and cost estimates. You can have our migration experts assist you or have us do all the work. We also have a full suite of tools, documentation, training, and best practices to guide you through doing the switch yourself.
Interested in trying out our new program? Read more about it here, or contact us to schedule your Oracle Migration Assessment today.
Are Oracle Price Increases Affecting Your Budget?
