Magnus Hagander's PostgreSQL blog - Comments

Lowe Schmidt: FOSS STHML #1

nospam@example.com (Lowe Schmidt) — Thu, 25 Feb 2010 14:14:15 +0000

Tack själv! Även om jag inte är tillräckligt insatt i databaser för att förstå storheterna i detta var det intressant

Magnus: Summary of feedback from FOSDEM devroom

nospam@example.com (Magnus) — Tue, 23 Feb 2010 07:08:48 +0000

Well we *did* mention it

The others we didn't do though. We had the URL on a board next to the speaker, but it wasn't a short one. I guess we could use an URL trimming service for it next time. It also does require you to login, which is probably a bigger obstacle to use it from a phone, really.

Not to keen on the dead tree version for obvious reasons, but I guess it might help with the number of people responding...

Selena Deckelmann: Summary of feedback from FOSDEM devroom

nospam@example.com (Selena Deckelmann) — Tue, 23 Feb 2010 04:35:11 +0000

One thing you can do is create quarter-page sized surveys that people fill out and drop in a box on their way out the door. And when introducing the speaker AND when applauding a speaker at the end of the talk: *mention* that the survey is there for them to fill out, and also provide a short URL that people could easily type into a phone.

Andreas 'ads' Scherbaum: Important updates for PostgreSQL Europe

nospam@example.com (Andreas 'ads' Scherbaum) — Thu, 18 Feb 2010 16:05:59 +0000

Good work so far!

Greg Smith: Time management by (somebody elses) press-releases

nospam@example.com (Greg Smith) — Tue, 09 Feb 2010 05:05:12 +0000

This is the sort of service you get when you're a Platinum sponsor. It includes a time machine to tell what talks will be accepted before the decision has even been made.

Devrim GÜNDÜZ: Time management by (somebody elses) press-releases

nospam@example.com (Devrim GÜNDÜZ) — Mon, 08 Feb 2010 20:32:57 +0000

C'mon... You are Magnus -- your each talk will be accepted.

Peter Eisentraut: Transferring slonified databases without slony

nospam@example.com (Peter Eisentraut) — Mon, 25 Jan 2010 11:01:06 +0000

There is also a script in the Slony source tree by the name of slony1_extract_schema.sh that attempts to solve this problem. It works by copying the schema into a temporary database, dropping the replication schema, and then re-dumping the schema. Might be worth comparing.

Dimitri Fontaine: Integrating django authentication with PostgreSQL

nospam@example.com (Dimitri Fontaine) — Thu, 14 Jan 2010 10:31:52 +0000

SELECT okFROM(SELECT encode(pgcrypto.digest(split_part(password, '$', 2) || _password, 'sha1'), 'hex') = split_part(password, '$',3) as okFROM auth_user WHERE username=_usernameUNION ALLSELECT false as ok)

LIMIT 1;

Magnus: Integrating django authentication with PostgreSQL

nospam@example.com (Magnus) — Wed, 13 Jan 2010 20:00:27 +0000

Yeah, you can actually make it slightly faster using CTEs.

But it so happens to be that the function I cut it out from actually does some more stuff, so I didn't think of that at the time

(if you don't use a CTE for it, you'll create two scans of the table)

Dimitri Fontaine: Integrating django authentication with PostgreSQL

nospam@example.com (Dimitri Fontaine) — Wed, 13 Jan 2010 19:57:15 +0000

I guess this should be IF EXISTS (SELECT 1 FROM ...) rather than SELECT *, and IIRC 8.4 EXPLAIN VERBOSE will show why

But thinking some more about it I guess I'd have written it in pure SQL.

Nitpicking apart, it's good to see pg people using some FLOSS stack, times are such that we should see a raise in PostgreSQL usage in Open Source products. And I think the project is ready for that.

Mathieu Fenniak: 64-bit Windows in PostgreSQL

nospam@example.com (Mathieu Fenniak) — Mon, 11 Jan 2010 15:54:19 +0000

I ran my application test suite against this build as well. I ran into (and fixed) a few 8.5 issues, but nothing unexpected. It seems to work well.

Eric Comeau: 64-bit Windows in PostgreSQL

nospam@example.com (Eric Comeau) — Mon, 11 Jan 2010 11:43:45 +0000

If you check out the free versions of Oracle Express there are no 84-bit versions as well...

Magnus: 64-bit Windows in PostgreSQL

nospam@example.com (Magnus) — Mon, 11 Jan 2010 09:40:51 +0000

Great, thanks for testing!

Matt Haley: 64-bit Windows in PostgreSQL

nospam@example.com (Matt Haley) — Mon, 11 Jan 2010 05:27:54 +0000

All 2360 tests in my rails application passed against this alpha.

It works for simple stuff at least.

Leo: PostgreSQL vs 64-bit windows

nospam@example.com (Leo) — Mon, 11 Jan 2010 04:06:44 +0000

As far as ODBC What about these ones -- I've been using these on 64-bit?

Had some finicky issues with this one:

http://code.google.com/p/visionmap/wiki/psqlODBC

-- this one ironically seems t work a little better though its older and more experimental:

http://www.geocities.jp/inocchichichi/psqlodbc/index.html

As described here:

http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html