[GENERAL] bit/integer operations in postgres

2006-01-01 Thread littlebutty
Does anyone know how I can solve this problem in Postgres: I am creating a table of user permissions. I want to represent each permission as a bit location. Each new permission I add to my system would be assigned to the next available bit (or column if you will) That way I can simply turn on a

[GENERAL] storing PDFs

2006-01-01 Thread littlebutty
I have written software that will dynamically create PDF documents used within my web application. Because each document is unique, I would like to store the resultant PDF into a field of the DB. Currently I just store the file to the server's hard drive and insert a path to the file the database,

Re: [GENERAL] Tool for database design documentation?

2005-08-04 Thread littlebutty
Not a free utility, but a good one: http://www.datanamic.com/dezign/index.html ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your mes

Re: [GENERAL] PostgreSQL vs. MySQL

2005-08-04 Thread littlebutty
Ou company just migrated in the opposite direction. We moved from MySQL 4.1 to PostgreSQL 8. We had serious issues with MySQL and foreign key support as well as data validation. For example: MySQL will simply insert an empty string value for a required field that was not supplied. We also incre