Re: [GENERAL] Beginner's Questions

2007-03-10 Thread Anton Melser
On 3/10/07, Don Lavelle <[EMAIL PROTECTED]> wrote: > Hi, all, > > Thank you all for your help! From what I've gathered, similarly > sized projects run on 100 MB of disk space and a 450 MHz processor. > My GUI and application logic aren't going to need much more than > that, so I should be good to

Re: [GENERAL] Beginner's Questions

2007-03-09 Thread Damian C
We produce and sell a Java desktop app, distributed in an office (~1-10 Users), with Postgres as the central data store. The users are "technically illiterate", and they often have very low spec hardware. It does all work very well. Note that for postgres you will need NTFS (WIN32 is not possibl

Re: [GENERAL] Beginner's Questions

2007-03-09 Thread Don Lavelle
Hi, all, Thank you all for your help! From what I've gathered, similarly sized projects run on 100 MB of disk space and a 450 MHz processor. My GUI and application logic aren't going to need much more than that, so I should be good to go! PostgreSQL it is! I'm sure I will have many, ma

Re: [GENERAL] Beginner's Questions

2007-03-09 Thread Michael Schmidt
Don, It sounds like your project is similar to mine. My app is a scientific database that contains journal articles and data related to neuropsychological assessment. The goal is to support evidence-based clinical practice as well as to serve as a basis for research and a book I am working on.

Re: [GENERAL] Beginner's Questions

2007-03-09 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/09/07 06:03, Don Lavelle wrote: > Hey, All, > > I'm working on a project (for a friend and for self-education) and want > to learn a little more about what sorts of applications PostgreSQL is > used for. I'm currently looking at a single-comput

Re: [GENERAL] Beginner's Questions

2007-03-09 Thread Jorge Godoy
Don Lavelle <[EMAIL PROTECTED]> writes: > My database is quite small (only 13 lucky tables, though that may expand a > little) and will not hold a great amount of data. (There will be at most > records in the thousands for the single-user or tens of thousands for the > multi-user.) I will eith

Re: [GENERAL] Beginner's Questions

2007-03-09 Thread tom
I'm running my database on a Pentium 2 with 450MHz CPU. It runs dbmail and spamassassin's Bayes and has overhead available. You'll find it works well enough for your database size. As for being it overkill. I think you've answered your own questions: I don't have to write as much code -- less bu

[GENERAL] Beginner's Questions

2007-03-09 Thread Don Lavelle
Hey, All, I'm working on a project (for a friend and for self-education) and want to learn a little more about what sorts of applications PostgreSQL is used for. I'm currently looking at a single-computer desktop application that may be scaled to a client-server model with multiple deskt

Re: [GENERAL] Beginner's questions about creating a custom data type in PostgreSQL...

2006-07-25 Thread Merlin Moncure
On 7/25/06, Redefined Horizons <[EMAIL PROTECTED]> wrote: Merlin, I am actually working on a spatial extension for PostgreSQL that is similar to PostGIS, but compatible with a geometry library I am developing. I had first thought of using a "table" only desgin, with no custom data types, to stor

Re: [GENERAL] Beginner's questions about creating a custom data type in PostgreSQL...

2006-07-24 Thread Redefined Horizons
Merlin, Thank you very much for taking the time to write that detailed response to my question. I appreciate it very much. You have helped me understand my design issue better, but I have another question if you have the patience to answer! :] I am actually working on a spatial extension for Po

Re: [GENERAL] Beginner's questions about creating a custom data type in PostgreSQL...

2006-07-24 Thread Merlin Moncure
On 7/24/06, Redefined Horizons <[EMAIL PROTECTED]> wrote: I've got a few questions about creating custom data types for PostgreSQL. ok, i have a weakness for medieval stuff, so: I'm not sure how to phrase the questions without an example, so here goes: I'd like to create a custom data type r

[GENERAL] Beginner's questions about creating a custom data type in PostgreSQL...

2006-07-24 Thread Redefined Horizons
I've got a few questions about creating custom data types for PostgreSQL. I'm not sure how to phrase the questions without an example, so here goes: I'd like to create a custom data type representing a Medieval Knight. (This isn't what I really want to do, it's just an example.) One of the "pro