An app needs a "Setup the Database" routine correct ?

Alex Clay aclay at
Wed Jan 24 15:43:11 EST 2018

Hi Das,

For a new database you might want to ship a backup with your schema and defaults pre-configured. Have the user restore this backup, then add their own custom data.

Yes, you need some kind of setup routine to get the server and database up and going. This can be as simple as giving the user instructions for how to setup, configure, and manage a PostgreSQL server, or as complex as a GUI from Omnis that installs PostgreSQL, sets up the database and manages maintenance operations like backups, restores, and schema changes. How you proceed will likely be primarily influenced by the technical capabilities of your users.

I recommend reading through the PostgreSQL docs from cover to cover, then taking a second pass when you have some more of this under your belt. This will give you great exposure to the terms and concepts that exist. Plus, the PostgreSQL docs are some of the best technical documentation I've seen.


> On Jan 24, 2018, at 15:29, Das Goravani <das at> wrote:
> When you have say a vertical app moreso than a single enterprise using an app you constantly maintain as more of an IT person, you need a routine in the Vertical which is the “Setup the Database” routine, and would make server tables from schema’s say, make the indexes, create sequencing tables, would basically prepare the database for use.  This routine would be first in the “utilities” section of the app. 
> Does this sound correct?  A setup the database routine that’s all worked out so you don’t have to do anything manually to setup the database?
> Just wanted to check before I write one.  
> And I need a heads up on maybe they’re called “joins”… that which makes it possible to easily pull in associated parent or child records (I don’t know which way it goes).   I’ve heard it hinted that this is possible so that it’s less work and quicker.  I don’t know what words to look up.
> I heard the word “nextval()” from Bastiaan so today I’m studying “create sequence” and “nextval” for that functionality. 
> I just need to hear the words so I can look it up.  Of course more than the words is good too. :) Pointers, help, welcome.  
> _____________________________________________________________
> Manage your list subscriptions at

More information about the omnisdev-en mailing list