Home > .NET, CodeGear, Database, Delphi, Fun, PostgreSQL, Programming, Windows > Creating a PostgreSQL Database with TUniScript

Creating a PostgreSQL Database with TUniScript

Amazing, just amazing. Some software and some developers can not be praised enough. I’m talking about PostgreSQL Database Server, and its excellent features, and its price.

I newly started using PostgreSQL, and believe me, it is one of the most advanced database server in the world.

Combined with a form of fusion (Universal Database Access Components – UniDAC), the Delphi coders found all the energy the would ever need.

I’m to explain how to create a PostgreSQL Database with TUniScript component. I am unable to find a real world example when I first started using UniDAC components.

So here we go. Drop TUniConnection, TPostgreSQLUniProvider and TUniScript components to a form.

Set TUniConnection’s properties, but leave the Database property blank. Set UniScript’s NoPreconnect property to True, and paste this into the SQL property of UniScript component.

DROP DATABASE IF EXISTS "mydatabase";
CREATE DATABASE "mydatabase"
WITH OWNER = postgres
ENCODING = 'UTF8';

Because we didn’t specify a database while setting properties of UniConnection component, we should set it in our code after our database is created:

UniScript1.Execute;
Sleep(5000); // Delay for database creation
UniConnection1.Database := 'mydatabase';

I have added another TUniScript component for adding tables, and it includes table creation data and referential integrity information. After database is created, I’m calling it to create tables:

UniScript2.Execute

And that’s it. We have created a PostgreSQL with Delphi and created tables at runtime. UniDAC is an extremely powerful native component set for Delphi.

A must for a serious programmer.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: