#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    1
    Rep Power
    0

    Suitability of PostgreSQL


    Good Day

    New to this Forum!!!

    Can you please answer for me a basic simple couple of questions about PostgreSQL.

    I am a Single-User on a stand-alone computer running the PCLinuxOS 2012-2 (rpm based) Op-Sys and need to urgently convert, or re-create, my Membership Database from another program to a better, and safer, DB. This product has been recommended to me!!

    I do not need fancy functions or add-ons. I have approx 2500 records with 70 fields and three graphics, (1 Symbol and 2 photos), per record. I also need a basic Query mode and simple reporting to print out. What I need is a solid reliable product that works correctly and does not "crash" and give problems.

    My questions are...

    1) Would PostgreSQL be suitable for this and will it run on my system?
    2) I MUST have a good WYSIWYG Form Designer and GUI Front-end to run my Database. What do you suggest for this?

    If your reply is in the affirmative I will get active on the Forum etc and start to learn and implement the program ASAP.

    I thank you in advance for your reply.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,785
    Rep Power
    348
    Originally Posted by IanZS6CDX
    1) Would PostgreSQL be suitable for this and will it run on my system?
    For such a tiny dataset? Absolutely.

    2) I MUST have a good WYSIWYG Form Designer and GUI Front-end to run my Database. What do you suggest for this?
    No idea. MS Access is a decent front end GUI tool as far as I know.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2009
    Posts
    7
    Rep Power
    0
    1)Yes, postgreSQL would work fine for this.

    2) If you want something fast, easy, and solid then Real Studio the Professional version works very well. I think you can get a 30 day trial. After that I believe it is $299. If you are looking for "free" then Gambas might not be a bad choice. Both of these run on Linux.
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2009
    Location
    Wenatchee, WA
    Posts
    7
    Rep Power
    0
    Postgres FORMS might be of interest to you...

    http://pfm.projects.postgresql.org/

IMN logo majestic logo threadwatch logo seochat tools logo