I’m just back from my one-day trip to the Linuxday 2007, this year in Berlin. The German PG User Group was not present with a booth. My trip was (among other things) to decide, if we will have a booth next year.
I’m just back from my one-day trip to the Linuxday 2007, this year in Berlin. The German PG User Group was not present with a booth. My trip was (among other things) to decide, if we will have a booth next year.
The Free Software Magazine has a nice article about the organisers and the organisation of the PGDay 2007 in Italy:
The PostgreSQL Usergroup Germany will have a booth at the FOSDEM 2007 in Brussels. Many of the usual suspects from the European Communities will be there.
On a student platform we show, on every page, a random user in the upper right corner. Because we have over 11.000 users, the database has to select all matching users and sort them by random(). Thats very expensive and one of the longest running queries in the current version. And because we are currently redeveloping the whole platform, I decided to try something different for the random user. The user must not be really random, it should be enough to just display a different user every time the page is displayed. My idea was to implement a ringbuffer in SQL and forward the pointer to the next user in the buffer if we need to search the next random user.
The German PostgreSQL Usergroup (website here) will have a booth at the Linuxday in Chemnitz.
Ever had the need to know what happened with your data? Tablelog could be your answer.
Since a lot of people asking for a Sequence without gaps:
tweakers.net has again tested the performance of PostgreSQL 8.2-dev and MySQL 4.1.20 and MySQL 5.0.20a. Results are nice and shown here.
Best thing: the collapse for requests per seconds if MySQL has a concurrency greater than 7. Oh, and by the way, they don’t state the table type for MySQL so we don’t know, if it is the fast and forgetfully MyIsam or the better but slower InnoDB type.
PGCon is an annual conference for users and developers of PostgreSQL, a leading relational database, which just happens to be open source. PGCon is the place to meet, discuss, build relationships, learn valuable insights, and generally chat about the work you are doing with PostgreSQL. If you want to learn why so many people are moving to PostgreSQL, PGCon will be the place to find out why. Whether you are a casual user or you’ve been working with PostgreSQL for years, PGCon will have something for you.
devx.com has a fair comparisation about the two databases engines, not looking at the speed but at more important points like features, ACID, transactions or commercial and 24/7/365 support. In other words, all the things you want, if you decide to use a database in a production environment.