[GENERAL] JOIN and difference between timestamps

I'm trying to find a count of records based on a number of factors, one of them being that records in different tables have been created within 1 hour of each other. The tables in question look like this: character_tbl Column |Type | Modifiers

[GENERAL] ER Diagram design tools (Linux)

I was wondering if anyone knows of any good ER Diagram tools for Postgres that run on Linux. I have been using DBDesigner by FabForce for a couple of years, but development has stopped while MySQL workbench is being built (for windows only). Neither of these applications will talk to Postgres and

[GENERAL] User permissions/Data separation.

I understand that this has been discussed before, but I was hoping that somebody might have some fresh ideas on the problem. I'm using Postgres for my web app, I users that interface with the database through the app. All records are classified with an industry and an occupation. Currently