Skip site navigation (1) Skip section navigation (2)

ANNOUNCE: tksql (program) & sdsql (Tcl/Tk package)

From: Sandro Dentella <sandro(dot)dentella(at)tin(dot)it>
To: pgsql-announce(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: ANNOUNCE: tksql (program) & sdsql (Tcl/Tk package)
Date: 2001-05-19 08:40:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-announcepgsql-generalpgsql-novice
                ANNOUNCE sdsql - Tcl/Tk packages


I'm happy to announce the first public realease of sdsql package (tcl/tk
library) and tksql a program to edit tables of a postgreSQL database.


sdsql:  provides editDb and popSqlQuery. The first is a proc to open a
        TkTable to edit postgreSQL tables, the latter is a procedure to
        interact dynamically w/ a database.

   features: * one line command to allow editing of postgreSQL table
             * easy way to trigger tcl procs as row/cell validation
	     * easy way to filter the database interactively
	     * two views: table view w/ TkTable or "mask" (Record in a Page)
	       editDb -tbl abc -mask 
	     * capability to edit a join statement (limited to *the first*
	       table in the 'from' part of the query. Read Docs)
	     * possibility to define conditions to add to every reload of
   	       the database, so as to limit the view of a table or to allow to
	       add join conditions
	     * easy possibility to change column represented and ordering
	     * possibility to define regexp to force constrain on some
  	       fields or foreign-key-sort of constrain in the application
	       throught a table of attribute definition
	     * hooks for logging-capabilities (I do simple replication of
   	       database throught that)

tksql:  This program allows you to edit tables of databases. You can use it
        from the shell prompt in any of these ways:
	    (myhost) $ tksql
	    (myhost) $ tksql -host
	    (myhost) $ tksql -host localhost -db mydb -tbl tel 
	    (myhost) $ tksql -db mydb -sql "select attr1,attr2 from table_a \
                   where attr3 = null"
         in all these cases you will be able to edit the table. If your
         select statement is a join tksql will work in read-only mode or will
	 let you edit only the first table.
         Comparison to PgAccess: PgAccess is a more mature peace of software
         and provides some capabilities (tools to create the database,
         change the structure, create or change functions...) that tksql
         does not have (nor it will in the future).

	 I consider tksql it is more flexible as an editing tool (filters,
         motion in the table, completion of attributes where
         applicable). Uses TkTable. 

Release Notes

    This is the first public release. The program has been used in a
    production environment for several months.


    sdsql and tksql is released under the GNU General Public License.

### Home page      ############

There's a home page for each project:

### Mailing lists  ############
I started a couple of mailing lists:

sdtcl(at)pcco2(dot)mi(dot)infn(dot)it:  devoted to development of sdtcl and use of package
sdsql(at)pcco2(dot)mi(dot)infn(dot)it:  devoted to development of sdsql and use of package

to subscribe you can visit the pages:

I welcome any comments, suggestions, or bug reports that you might have.


sandro dentella

pgsql-novice by date

Next:From: Matus "fantomas" UhlarDate: 2001-05-20 21:31:29
Subject: asynchronous queries
Previous:From: Manuel SugawaraDate: 2001-05-18 16:22:00
Subject: Re: SQL query help - online music shop - labels & styles

pgsql-announce by date

Next:From: The Hermit HackerDate: 2001-05-25 17:09:48
Subject: PostgreSQL v7.1.2 Now Available ...
Previous:From: Robert DaleDate: 2001-05-17 19:29:59
Subject: Sql2Dot

pgsql-admin by date

Next:From: BhuvaneswariDate: 2001-05-19 09:18:53
Subject: Error in installing pg-access
Previous:From: Peter EisentrautDate: 2001-05-19 08:16:18
Subject: Re: Script to createuser

pgsql-general by date

Next:From: Lamar OwenDate: 2001-05-19 11:20:16
Subject: Re: PostgreSql and Caldera
Previous:From: Tom LaneDate: 2001-05-19 03:54:47
Subject: Re: Inserts using plpgsql - Further

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group