Datamodel designer for PostgreSQL / News: Recent posts

pgDesigner-1.2.0 update packages

For a problem in compiling programs Gambas2, I republished the latest pgDesigner.
The problem is caused by the fact that during the building, the compiler includes without distinction all files and directories in the draft, significantly increasing the size of executable final.
Although this does not cause problems in the program, I still correct the anomaly, in order to facilitate the downloading packages.

Posted by Carlotto Luigi 2008-02-06

pgDesigner 1.2.0 Released

UPD: Changes adaptation to the new version of Gambas2.
UPD: Improvements to the code.
BUG: Fixed a problem in loading areas of a report during the procedure reverse-engineering.
NDA: Program compiled with version 2.0.0 of Gambas.

Posted by Carlotto Luigi 2008-02-03

pgDesigner Web Documentation Update

Updating Web pages, translated into English.

Posted by Carlotto Luigi 2007-12-03

pgDesigner Web Documentation Update

Updating Web pages, translated into Italian.

Posted by Carlotto Luigi 2007-12-03

pgDesigner 1.1.0 Released

NEW: Changed the whole application logic, as well
as the interface of the main window and the
project.
NEW: Adding the toolbar in the application window,
with a few buttons utility in the main menu.
The bar is located under the main menu, and
can be hidden acting in the general
configuration.
NEW: Implementation of the search function of
objects within the projects open. The
research will be carried out on the names of
all objects in all projects open (active or
not), which correspond, in whole or in part,
the string set in the dialog box and the
result is shown in a list on the same window,
complete with all references to each subject.
The search can be made on the name, in which
case you can enter in the classical string
wildcards (eg '*', '?', Etc..). The function
is under the Edit menu in the main menu.
NEW: If executed by a shell, you can go to a list
of files to be set by typing below the name
of the program the names of the project file
(ini formats and XML, excluding sql) complete
the directory in which they are present. The
absence of the file does not cause any error
messages or warning.
NEW: In the editing window objects Table, in the
list of columns has been added a feature that
allows you click with your mouse in a field,
placing or less in the primary key. (Adding
proposal and written by Rodrigo Ramirez
Norambuena).
NEW: By placing the mouse over a label of projects
open bar, a tooltip with some information
about the project assets (if the function is
enabled tooltip).
NEW: Now you can create the documentation of the
project in pdf format, thanks to a new
library. The new modules PdfWriter and
PdfWriterFont do my part of another project
(http://sourceforge.net/projects/pdfwriter/),
which is ported in Gambas the famous library
FPDF (http://www.fpdf.org ), written
originally as PHP language support, and I
hope that this news is useful only as a
demonstration of the potential of this
library. In this version, I set a fairly
simple document, as well as formats for text
and html. For the production of the report,
in addition to basic library is been created
class PrintPdf for managing print header and
the bottom of the pages following the logic
of the new library. After saving the file,
the report will appear in the format chosen
on a dialog box.
NEW: Adding an option for automatically saving
projects open. In the dialog settings general
is the new option in the form of a field in
which enter or select the period of time
between saves. This time is expressed in
minutes, in steps of 5 minutes, the change
takes account of this and automatically
corrects the values manually entered bringing
the value to a number of 5 lower. A value of
zero disables the function. The feature is
disabled by default.
NEW: When creating a report has been added a
feature that adds the fields belonging to the
primary key in the establishment of origin in
the destination table, the operation is
performed only if the fields are not already
present. If the creation of the report is
canceled, added fields are eliminated. In
addition, the new feature provides an
automatic combining the fields of the two
tables, putting related fields with the same
name, taking as reference the key fields of
the table of origin; remains available to the
user the ability to alter this association.
NEW: For objects of type Area has been added Bold
ownership, which allows you to set the
release of the text in bold.
NEW: The status bar has been added information on
the current printer settings on the current
project.
NEW: In the modified procedure was added a button
that opens a dialog box where you can select,
with the double click of the mouse, one of a
kind provided by the driver Postgres, the
name of the type selected will be added in
the declaration of input parameters the
procedure. The list appears in the window
includes the name of the type is a brief
description of its significance.
NEW: For items you can define table showing
details of the type of fields. The option is
included in the general settings, and it is
only if you are displaying details. As with
all other options general, the approach will
be applied on the project or, optionally, on
all projects open, but at the moment it is
not possible to define viewing on a single
display.
UPD: The dialog print diagram has been completely
revolutionized. The entire plot is divided
into pages relative to the current
configuration of the press, and presented in
a list of graphics by selecting a page from
the list, it is marked as active page and
displayed in larger size. Each page contains
basic information of the project, the page
number and the date it is produced. On top of
the window displays some basic information of
current print format, which you can edit
through the setup button, always on the same
window; any change in configuration of the
press will be reflected on the diagram that
will be recalculated on the basis of the
format print selected. As in the previous
version, you can print the entire chart on a
single page, and save it to file image, in
the case of most pages produced many files as
there are pages numbered in the order they
are presented on the window. The print
resolution is fixed and is set to 150 pixels.
BUG: Fixed vary bugs.
NDA: Program compiled with version 1.9.91 of Gambas.

Posted by Carlotto Luigi 2007-11-30

pgDesigner 1.0.1 Released

UPD: Modifications of the objects of database for
a greater control of the data regarding the
version of PostgreSQL used in the plan.
UPD: Modifications of the function of import from
rows sql, with adding of the controls on the
compatibility of the objects with the version
of PostgreSQL of default.
UPD: Modifications on the controls in the windows
of dialogue for the parameters of
import/export on database. In particular
check of objects TYPE not disable check for
the TABLE and the PROCEDURES, than previously
it was inserted in order to avoid errors in
the case these last ones contained types
constructed from the customer.
BUG: Corrected a problem with the loading and the
management of objects TYPE of PostgreSQL. The
window of dialogue for the management of this
type of object modification has been modified
of consequence.
(kindly marked bug from Antonio Prado)
NDA: Program compiled with version 1.9.50 of Gambas.

Posted by Carlotto Luigi 2007-08-27

pgDesigner 1.0.0 Released

NEW: Added the translation in Chinese of the
witnesses and the messages, thanks to the
contribution of the friends Henri and Yanqing
Girard.
NEW: Added the push-button of "Connection Test" in
the window of login, for the verification of
the logon parameters.
NEW: In the window of edit of the tables it has
been added the Triggers folder, that it
visualizes the directory of the trigger
connects you to the same table. Through the
same card it is possible to directly manage
the trigger of the table, to create some of
new, to modify them or to cancel them.
NEW: The selection with the double click of the
left key of the mouse, in the list of the
Display in the window "Statistics of plan",
renders assets the display relative. Same
identical behavior selecting an element in
the lists objects or you live, that it
renders assets the evidenced object. If the
object is found to outside of the visible
area, will come carried out scroll an
automatic rifle so as to to visualize the
object.
NEW: During the selection of an object (manual or
automatic rifle), if this is found to outside
of the visibility, the window will come
carried out the scroll until the point in
which the object will be found.
NEW: In the window of edit of the procedures it
has been added to the folder Connections,
that it visualizes the directory of the
objects that make reference the selected
procedure (triggers, other procedures). The
connection with other procedures happens
analyzing to the content of the definition,
verifying the presence of the name of the
selected procedure.
NEW: In the window of edit of the tablespace it
has been added to the folder Connections,
that it visualizes the directory of the
objects that make reference the tabelspace
selected (tables, indices).
NEW: A new object has been inserted: "Stamp", that
it visualizes in the diagram some information
of identification of the plan. The object can
be managed like all the other objects of the
plan, but it cannot be modified; the
visualized information come dawned
automatically to every modification of the
plan.
NEW: Added the possibility to modify the every
color of single object; in menu the
Modification of the menu main and the menu
popup Color has been inserted the voice
"object". The general configuration of the
colors is remained equal, except for the fact
that the management comes carried out to
total level like base formulation; every new
object will come therefore created with the
colors shapes to you in the formulations
generates them, allowing later on the
modification for every object singularly and
distinguished. The formulation will come
maintained also in phase of press of the
diagram. For this innovation it has been
necessary to modify the structure of the plan
rows, that they will come modernizes you
automatically to the rescue.
NEW: Added two push-buttons in the window of
formulation of the display, that they allow
to select or less all the elements of the
list.
NEW: In the rows of configuration of the
application it has been added an ulterior
voice "MaxRecent" that allows to set up the
maximum number of voices in the list of the
last open plans present in menu the Rows. In
any case, the maximum number must be
comprised between 0 and 30.
NEW: Added the new static class CColor, that it
contains the formulations of default of the
colors; they have been modified all the inner
references to the application so as to to
head for this new class.
NEW: Added the possibility to copy objects between
open plans. The functionality is accessible
dal menu main and dal menu popup, on
selection of an object dal active plan. The
copy is possible for all the objects to
exclusion of trigger, relations and stamp,
since it is not possible to associate valid
references in the destination plan. For this
reason that in the new objects created during
the copy they will come rendered invalids all
the link active presents in the object
originates them. Various for the sights,
since it does not come less carried out some
control on the existence or of the references
included in the query, the verification and
the eventual modifications comes left the
customer.
NEW: Implemented a function for the modernization
of the tooltip during the insertion of a type
of variable PostgreSQL in the dialogue
windows that preview it. The tooltip it
visualizes the information of base of the
selected type. For being able however to
visualize the tooltip it is necessary that
this functionality is active.
NDA: Program compiled with version 1.9.50 of Gambas.

Posted by Carlotto Luigi 2007-08-20

pgDesigner 0.0.41 Released

NEW: Begun the translation of the help in French,
thanks to the contribution of the friend
Henri Girard.
NEW: Help online, the all comprised the rows HTML,
hour are available on various rows
compressed. The installation of the help can
happen in according to time or omitted, in
this case the pages will come loaded from the
situated one web.
BUG: Corrected an error in the qualification of
the push-buttons of the objects selecting
version 8.2 of PostgreSQL.
NDA: Program compiled with version 1.9.49 of
Gambas.

Posted by Carlotto Luigi 2007-05-29

pgDesigner 0.0.40 Released

NEW: Adding translation in French of the witnesses
and the messages, thanks to the contribution
of the friend Henri Girard.
NEW: New additions inner classes (CDrag, CMouse,
CErrorProce ShowError), respective for the
inner control of the dragging, the position
of the mouse, the management of the errors
inner to the I/O procedures, the
visualization of the system errors.
NEW: Modified logic of design of the relations
between the tables, hour the relations come
identified with: continuous line if the
fields belong to the primary key of the table
daughter, line to points if the relation has
set up clause RESTRICT, line to point/line
for all the other not identificative
relations.
NEW: The windows of dialogue for the modification
of the objects have been modified, with
adding of a folder where it is possible to
see in preview tightens it DDL constructed
from the program on the base of the inserted
parameters.
NEW: In the window of dialogue for the
modification of the data of every object it
has been added one new folder that it
visualizes the relations father and son with
the other objects of the plan.
NDA: Program compiled with version 1.9.49 of
Gambas.

Posted by Carlotto Luigi 2007-05-27

pgDesigner 0.0.39 Released

NEW: To the start of the application it comes
introduced a dialogue window, that it allows
to set up the language, so as to to avoid to
set up it from commando line.
UPD: Modernizations for the new version of Gambas.
BUG: The windows EditTable, ViewWizard and
ShowStatistics have been modified in order to
correct a problem with the objects TableView
of Gambas. These objects have been replaced
with GridView objects.
NDA: Program compiled with version 1.9.47 of
Gambas.

Posted by Carlotto Luigi 2007-01-22

pgDesigner 0.0.38 Released

NEW: Added the module pgDesigner.module, that it
executes the launch of the application.
NEW: Added the new CApp class, for the management
of the application. All the controls managed
previously from the main window have been
transferred in this new class. The launch
comes carried out from the module pgDesigner.
NEW: Added the new CProjects class, like container
and manager of the plans.
NEW: Added the new CUtil class, that it contains
functions and static procedures of
usefullness and support.
NEW: Added the possibility to modify the
formulations of color of the objects. The
formulations come conserved in the
configuration rows, under shape of tighten
and in the format "r, g, b", and are valid to
total level for all the active and not active
plans. An appropriate window allows to vary
the configuration of base in every moment;
the variations come immediately applied on
all the open plans.
NEW: Added the possibility to visualize the
division of the diagram in pages; in
practical in the diagram they come visualized
of the lines of demarcation between the
component pages the graphical suit, that they
respect the real dimension of the format of
the press page. In the menu "Show" has been
added the voice "Visualizes pages" in order
to allow the management of this new
formulation. To keep in mind who, if
activated, this formulation can slow down the
refresh of the diagram, because of I redesign
of the lines to every change.
NEW: Added one new functionality, that it allows
to define of the areas, profits in order to
evidence the objects in groups work them.
These zones have rectangular shape, with
color defined from the customer, and on which
a single one can be inserted tightens of
text, like famous descriptive of the area.
The dimension begins them of the zone comes
defined in phase of creation, to clicked in a
point of the design area, and dragging the
mouse until when the intentional dimension
is not caught up. For the management of this
new object it has been added in the plan the
new WArea class. The modification of the
formulations comes carried out through an
appropriate window of dialogue, selecting
the object with the skillful text of mouse or
the double quantity click; it is possible to
modify of the text, the color of filling, the
coordinates and the dimensions of the
rectangle, or to eliminate it from the plan.
The objects of this type will come save you
with to all the other elements in the plan
rows. To keep in mind who the management of
this type of object holds account of the
order of creation in the plan, for which the
last elements they will cover always those
previous ones if overlapped; moreover and it
is visible single in the display on which it
has been created. In the menu main it has
been added one new voice for the
formulations of visualization of this object.
NEW: Added the possibility to create a plan
loading the information from rows containing
commandos sql. The loading can be carried out
through the same procedure of loading of the
plans, selecting opportunely the rows from
disk with the correct extension. At the
moment this function is still in a phase of
test, for which errors with rows can be taken
place not correctly set up to you.
NEW: Added the CLog class for the management of
the log files for the messages and the errors
applied to you. At the moment in the log the
errors gushed from the procedure of creation
of the database come saved.
NEW: In the menu main, under the heading of It
visualizes, it has been added the call for
the visualization of the log of the
application.

Posted by Carlotto Luigi 2007-01-15

pgDesigner Web Documentation Updated

The Home Page of pgDesigner has been dawned with the new documentation of the program. This comprises all the modernizations until to the current version of pgDesigner, comprised the detailed lists of the plan and configuration rows.

Posted by Carlotto Luigi 2006-12-14

pgDesigner 0.0.37 Released

NEW: Added the management of the display (or
view). With display (or view) the possibility
agrees to create of the sights of the
project, every containing a group of objects;
for group the same logic agrees with of
elements making part of one. As an example:
it is possible to define a display that it
contains the sun tables of codifies, or with
of all the procedures. The display it will
show in the graphical area the single objects
that make part of the group; an appropriate
window allows to insert or to remove elements
from the group, without to influence in the
physical construction of the plan. The
management previews a display of default,
called "Main View", that it will contain all
in any case the elements of the project,
prescinding from several the groupings. The
relations will come only visualized if in the
display active the relative tables are
present. An object created to the inside of a
display various from the "Main View" will
come however created in the display main,
same thing if it comes cancelled an object
from the project, this will come eliminated
in all the display on which it was present. A
display it can be created, be modified or
cancelled, without to influence on the
project. Every display it comes identified
from a name and it can contain one highly
summarized description. The management window
is accessible from the menu main; the
selection and the visualization of a display
can be carried out from menu the Project or
combobox present under the directory the
object of project, visualized in the area to
right of the window of the program.
NEW: In menu the Modification they have been added
two voices: "Copy on display" that it allows
to copy the object selected on an other
display, and "Eliminates from display" in
order eliminating an object from the display
active. This last voice is qualified single
on the display various from that main one, on
which it is not obviously possible to carry
out this type of operations.
NEW: To the exit of the application, if they turn
out to be present new projects or modified
not still it saves, it comes introduced a
warning window with which it is possible to
decide if to proceed to their rescue or to
cancel all the modifications. In the case
confirmations the rescue, the closing will
proceed introducing messages of every
confirmation for single plan not still saved.
NEW: Resolved the problem of the loading of the
files of project in format xml. The
modifications completely have changed the
structure of the files of project in format
xml, for which the created projects the
previous versions could not be retrieve to
you; for being able to convert the previous
projects it is necessary to succeed to load
them with the previous version with
pgDesigner and saving them in format ini. To
notice that the time of loading of the rows
in format xml turns out to be slower
regarding the type rows ini.
NEW: Adding evidentiation of the commandos sql in
the extraction window.
NEW: In the window of visualization of the
commandos sql it has been added a menu, with
which it is possible to print or to save on
files the visualized text.
UPD: The printing of the project diagram is
modified for the new management of the
display. The management hour print/save the
image of the display active.
UPD: Hour it is possible to define the author of
the project; the name will come saved in the
project files, and visualized in the printing
and the diagrams.
UPD: The display previously saved in the project
files hour it immediately becomes the display
active, so as to to be restored in the
successes to you loadings and to be
visualized.
UPD: Optimization of the menu "Show".
UPD: Improvements of the functions of printing of
the project diagram.
UPD: All the procedures that carry out massive
operations hour use the same window of
progression.
UPD: Modernized the window of project statistics,
with the added one of the list of the display
active.
UPD: Modified label PROCEDURESQL in the files of
project with the label PROCEDURES; in any
case it comes maintained logic of loading for
being able to read the files of previous
versions. To notice that in the next versions
the compatibility more will not be supported.
UPD: Rewriting of the objects and the functions of
creation sql, and import/export.
UPD: Modernization of the structure of the
messages.
UPD: Optimization of the classes, the objects and
the inner procedures.
UPD: Modernizations for the new version of Gambas.
BUG: Corrected the activation of the voices of the
menu popup.
BUG: Corrected a problem of visualization of the
relations with the fields not primary keys,
when the detail is set up to hidden. The
problem was taken place alone with the
formulation of visualization of the points of
attachment is directed on the fields.
BUG: Corrected driver the PostgreSQL for the
versions from the 8.0 to the 8.2, because of
one query for the survey of the objects
sequence in the database.
BUG: The function of creation of the database has
been corrected, because of a problem with the
objects sequence.
NDA: Program compiled with version 1.9.43 of Gambas.

Posted by Carlotto Luigi 2006-10-04

pgDesigner 0.0.36 Released

NEW: Added to the management multiproject; hour it
is possible to open/create/modify more
projects at the same time. Every single
project has its area of design and its list
of objects, is possible to select a project
through the tab present in the tree to the
right of the window of the application or
from menu Project.
WARNING! To use with caution, the management
is still in phase of test.
NEW: Is be added a new algorithm, that it allows
to visualize the relations coupled to the
fields of the tables. The departure point
comes coupled on the skillful side of the
table father, while on the left side of the
table daughter. Consequently they have been
added the respective voices of menu under
"Show/Relations".
NEW: The right key of mouse on the title it of the
panel active list objects menu the Project
for the running project.
NEW: Added a splash screen to the departure of the
program.
NDA: Program compiled with version 1.9.40 of Gambas.

Posted by Carlotto Luigi 2006-09-06

pgDesigner 0.0.35 Released

UPD: It restores the bar of the title it and the
push-buttons to you standard in the dialogue
windows, previously disabled you for a
problem with the event of closing from these
last ones.
BUG: Corrected a problem of the exec with the
loading of the icone of the program.
NDA: Program compiled with version 1.9.39 of Gambas.

Posted by Carlotto Luigi 2006-08-21

pgDesigner 0.0.34 Released

NEW: Added the voice "Creates database", that it
allows to directly create the objects on a
database existing. Because of eventual
problems that can derive from several the
connections between the objects, the function
tries to create the objects in various
passages; to every passage they come created
the objects that are not successful to create
to the previous passage. The maximum number
of passages corresponds to the number of
objects contained in the project, dependent
from the outcome of every elaborative step.
ATTENTION!!! The function is still in phase of test;
at the moment the modernization of the
objects is not previewed, comprised the
creation of the tablespace, the data
contained in the tables comes cancels to you.
NEW: Hour it is possible to visualize menu popup
also in the list the objects of the project.
NEW: Under the directory of configuration of
pgDesigner the folder is present "log", in
which they come saves the log to you of the
last operations of input/output.
NEW: Introduced the management of object "TYPE" of
PostgreSQL. The management is incomplete and
still in phase of test, to use with caution.
NEW: In menu Show it has been added a new one
sottomenu, with some voices for show/hide the
objects in the diagram. All the objects,
except the tables and the relations, can be
rendered visible or be hidden at the view.
UPD: Restructure of the voices of menu
Modification and Project.
UPD: The MenuPopup class has been eliminated, hour
the menu popup comes directly created from
the voice Modification of the menu main.
UPD: The objects text hour come visualize to you
with a contour in clear gray, that it allows
to identify of exactly the margins.
UPD: Carried out some relative modifications to
the new version of Gambas.
UPD: The font of the definitions of the functions
and the sights in the windows of editing it
has been set up to Courier for one better
reading.
UPD: The version of PostgreSQL used in the project
conditions the visualization and the use of
the objects. To select a version previous to
that one current provokes to the cancellation
of all the objects not previewed from
PostgreSQL.
UPD: Modified the order of creation of the
commandos sql of the groups of objects; hour
the sights come created for last.
UPD: Some corrections and optimizations of the
procedures of input/output.
UPD: Ulterior assistants controls in the windows
of modification of the objects. For the
procedures he comes controlled the validity
of the parameters in input, that they must be
present in the list of the types recognized
and valid for the version of selected
PostgreSQL.
UPD: For the logon to the database it has been
added parameter PORT, for being able to
manage also the configurations not standard
of PostgreSQL.
BUG: Corrected a problem with the types
time/timestamp during the export of the
commandos sql relati to you to the domains.
BUG: Corrected a problem of loading of the
arguments of the procedures from the
database.
BUG: Corrected an error during the cancellation of
an object tablespace.
BUG: Corrected a problem during the export in sql
of the objects table.
BUG: Corrected a problem of loading of the values
of default of the tables from the database;
if the default it is a function, this comes
enclosed between double apexes.
BUG: Corrected a problem of loading from database
of the relative indices of table you to
primary keys, defined in way automatic rifle
from PostgreSQL and/or with equal name to the
primary key. Same behavior during the export
in sql and towards the database.
BUG: Corrected an error in the creation of the
commandos sql for DROP FUNCTION. The commando
does not come more create/execute, the scope
comes caught up with alternative CREATE OR
REPLACE FUNCTION.
BUG: Corrected a problem in the loading from the
database of the property of the functions.
BUG: Corrected a problem in the loading from the
database of the property of the trigger.
BUG: Corrected a problem on the loading from
database; hour the objects loads to you is
exclusively those pertaining to the customer
of login.
BUG: Corrected a problem of single/double apexes
in the comments of the objects, during the
writing of the commandos sql.
BUG: Eliminated the management of parameter "ON
INSERT" in the management/creation of the
relations, nonexistent in PostgreSQL.
BUG: Corrected a problem in the reading from the
database of the relations with more fields.
BUG: In order to avoid the block of the
application, when it comes pressed the
present push-button of closing in the bar of
the title it, it has been added to a
push-button of closing in bottom to the
visualization window extraction sql.
NDA: Program compiled with version 1.9.38 of Gambas.

Posted by Carlotto Luigi 2006-08-12

pgDesigner 0.0.33 Released

NEW: In menu the Project it has been added an
ulterior one submenu with which it is
possible to condition the visualization of
the lines of the relations between tables.
Hour it is possible to define if to show the
connections in direct way or with segment
line, this last one is the condition of
default. (modernization proposed from the
friend Jose Francisco Reinoza from the
Venezuela).
NEW: Added a control on the relation between two
fields not compatible; the control does not
block the selection but it introduces a
message of warning.
NEW: Added a control on the maximum dimension of
the name of the objects, defined based on the
PostgreSQL version set up in the project. The
containing objects of project names that
exceed this dimension will not come load, for
which it will be necessary to proceed
directly to the modification of the names on
the file with whichever editor. The names in
the windows of editing will come
automatically limit you to this dimension.
NEW: In the structure of the tables it has been
added the PrimaryKey property that it
contains tightens it of the name of the
primary key of the table. The value is not
obligatory, and comes set up automatically
from the program, to the name of the table
continuation from the suffix "_pk". In the
window of edit of the table, if a primary key
exists and the name is empty, it will come
set up to the value of default, and
introduced a warning message; otherwise if it
does not come selected some key, the property
comes cancelled. The same logic comes applied
during the loading of created objects of
project with previous versions. Is be
modified also the function of
reverse-engineering, so as to to read from
database also the name of the primary key. To
notice that, in any case, the dimension of
the name will come cut to the maximum
dimension admitted from driver of PostgreSQL.
(the modernization proposed from the friend
Jose Francisco Reinoza).
UPD: Modernized the supported list of the datatype
from PostgreSQL, in which they have been
added some lacking datatypes. The list of the
datatype is hour conditioned from the version
of selected PostgreSQL, for which some new
types they could be does not visualize to you
with previous versions. In projects created
with previous versions, some datatype could
not be more consistent to the list, and
assume various value; in this case it is
necessary to modify the version of the driver
in the window of the project parameters, or
to select datatype various for every single
object. This modernization is still in phase
of study, and the list could endure
variations in the next releases of
pgDesigner.
UPD: Improved logic of design of the graphical
objects.
UPD: Restructured the menu main. The voices of
menu relative to the visualization of the
details of the objects, the fields key and
the names of the relations, have been moved
in menu Show and total yields to the
application, that is more not tied to the
project; the formulations memorized in the
objects of project created with the previous
versions hour do not come taken more in
consideration and do not condition more
visualization of the objects. Also the window
of the project parameters does not introduce
more these formulations.
UPD: The windows of the parameters of project and
statistics have been modified; in particular,
the window of statistics, filler two lists,
in alphabetical order, of the present objects
in the project, and the fields contained in
the tables. It lists are in single reading
and to the single statistical ends and of
control.
UPD: The menu popup it has been implemented and
dawned with the carried out variations to the
menu main.
UPD: Many of the logical ones and the objects of
the program have been optimized.
UPD: The font of the window of visualization of
extraction sql/html it has been modified and
set up in Courier; this in order to allow
one better reading of the text and to better
show the spaces of the text lines. Moreover
hour is managed the spaces of the text of the
content of the procedures.
UPD: For the objects text, it has been added the
possibility to write the text on more lines,
and than to define of the positioning.
UPD: In the project objects it has been added the
property "Driver" that contains the
PostgreSQL version. For default, in the
creation of a new project, the set up version
is the 8.0; this can be modified through the
window of Setup of the project. In the
projects created with previous versions, the
version will come set up to that one of
default in phase of loading. To notice that
the insertion of the control of dimension of
the names of the objects could not allow the
variation of the version with release of
PostgreSQL previous, for which it will be
necessary to proceed directly before to the
manual modification of the names on the
objects, before carrying out the change of
version.
BUG: The formulation of the returns to head in the
property comment of some objects has been
corrected.
BUG: The strings relative to the property of the
objects of database hour they come cleaned up
of eventual blank spaces to the beginning and
to the end of it tightens (trimming).
NDA: Program compiled with version 1.9.31 of
Gambas.

Posted by Carlotto Luigi 2006-06-10

pgDesigner 0.0.32 Released

BUG: Corrected a small problem of visualization in
the window of dialogue for the plan
parameters.
BUG: Corrected a problem during the rescue and the
loading of a plan without objects.
BUG: Corrected a small graphical problem in the
List Objects, that it caused the modification
of the icon of a plan object setting up it
like a icon of group.
UPD: Modified the structure of the plan rows xml
(a problem still exists on the loading of
this type of rows, for which if of it it
advices against the use).
UPD: Modified logic of the state of dragging in
course.
NEW: Adding menu of a sottomenu in the File,
containing the list of last the 5 open plans.
From this list it is possible to load the
relative plan (if always still present in the
directory).
NEW: Hour it is possible to modify the coordinates
of the selected object, activating a window
of dialogue through double click of the mouse
in the statusbar, in correspondence of the
containing area the position puts into effect
them of the object, or from menu the
Modification or the menu popup with the
skillful key of the mouse. The window allows
to set up the point of positioning of the
object in the diagram, through the insertion
of coordinates X,Y in the design area.
NEW: The rescue of the plan hour has been divided
on two voices of menu: rescue of the running
plan on same the rows, new rescue on rows.
With the first option the plan comes
automatically saved on same the rows from
which it has been loaded the plan, except in
the case of rescue of one new; with the
second option it always comes demanded the
new name of the rows and the directory on
which saving it.
NEW: The new objects initially come puttinges in
the angle up on the left of the visible area,
and not more like previously in the relative
left advanced angle to the diagram.
NEW: In the list of the plan objects, for the
tables and the views they come visualizes
also the fields, evidencing the appropriate
keys with icons.
NEW: The dimension of the list plan objects comes
hour saved in the configuration rows; in this
way, to the successive one restart of the
program they will come restored the last set
up manually dimensions.
NEW: The movement of objects beyond the visible
area hour provokes scroll the automatic rifle
allowing to follow and to render visible puts
into effect it them position of the dragged
object.
NEW: Adding of parameters in the configuration
rows; the formulations of import/export come
saved in separate way.
NEW: Program compiled with version 1.9.30 of
Gambas.

Posted by Carlotto Luigi 2006-05-23

pgDesigner 0.0.31 Released

UPD: Modified the structure of the plan rows xml
(a problem still exists on the loading of
this type of rows, for which if of it it
advices against the use).
BUG: Corrected an error in the creation of the
indices on some versions of PostgreSQL,
during report in format the text.
NEW: The progression of the creation of the report
comes hour visualized on a dialogue window,
that sluice to the term of the function
comes.
UPD: Modified and improved the management of the
press of the diagram of the plan.
NEW: The progression of the rescue functions and
loading from rows, the export on rows and the
reverse-engineering, come hour visualized on
a dialogue window, that sluice to the term of
its function comes.
BUG: Corrected the function of loading of the
objects dominion from the database for some
versions of PostgreSQL.
UPD: Modified the names of some form.
UPD: Reorganization of the objects, in particolar
way has been modified the CProject object.
NEW: In the window of management of the press of
the diagram of the plan they have been added
two checkbox, with which single page is
possible to adapt the entire diagram to the
inside of one, and to save the diagram as
rows image (you form to you valid: png, bmp,
GIF, jpg and xpm). The dimensions of the rows
image correspond to the real dimensions of
the entire graphical area; the function
automatically supplies to eliminate the empty
zones to margin, only designing the area
occupied from the objects. Same thing for the
press on single page.
NEW: Program compiled with version 1.9.29 of
Gambas.

Posted by Carlotto Luigi 2006-05-02

pgDesigner 0.0.30 Released

NEW: Added the possibility, in the mask of edit of
the fields of the table, to move the order of
the fields in the directory.
NEW: The making fields part of a foreign-key come
evidence to you with a red graphical rumble,
while the normal fields with a square gray.
NEW: The points of attachment of the relations to
the tables come evidenced with red color for
the father, with green color for the
daughter.
NEW: The points of attachment of the relations to
the edge of the tables come reordered so as
to to respect the position of the objects on
the diagram.
NEW: Added the voice of menu "Show keys", that it
allows to show the single fields key of the
tables. The same voice has been added to the
menu popup.
NEW: The configuration rows come hour saved in the
directory "pgdesigner" in home the customer.
To the start this comes created does not
exist.
NEW: Hour comes saved in the configuration rows
the last one directory of the last one
loading/saving. For default it is the home
directory of the customer.
NEW: Program compiled with version 1.9.28 of
Gambas.

Posted by Carlotto Luigi 2006-04-19

pgDesigner 0.0.29 Beta Released

NEW: Added the Wizard push-button in the toolbar
for the guided creation of the views.
UPD: Modernized the ViewWizard for the guided
creation of the views.
BUG: Corrected a problem in the window parameters
of plan during the creation of a new plan.
BUG: Corrected a segment fault when it comes
finished the program or when it comes closed
without to save a modified active plan.
BUG: Corrected a segment fault when they come it
loads plans to you in consecutive way.
NEW: Program compiled with version 1.9.26 of
Gambas.

Posted by Carlotto Luigi 2006-03-22

pgDesigner for Fedora users

For who it did not succeed to install the package rpm on Fedora Linux, it is possible to find the necessary bookcases in one of the link indicates to you on the situated official of Gambas http://gambas.sourceforge.net/. In altewrnativa is possible to unload the last version from the situated one http://www.kudla.org/index.php?wl_mode=more&wl_eid=83 that, even if the packages refer to Mandriva Linux, are possible to install them also on Fedora.

Posted by Carlotto Luigi 2006-03-01

pgDesigner Web Documentation Released

The page web http://pgdesigner.sourceforge.net has been dawned.

Posted by Carlotto Luigi 2006-02-28

pgDesigner 0.0.28 Beta Released (BUG)

BUG: Corrected an error of loading of the relative
image to the primary-key in the windows of
editing of the fields and the indices of the
table and in the window of editing of the
relations.
BUG: Correction of some errors in the window
wizard of the sights.
BUG: Correction error loading objects text from
rows plan.
BUG: Correction error in cancellation object
tablespace.

Posted by Carlotto Luigi 2006-02-28

pgDesigner 0.0.27 Beta Released

NEW: Adding to window for the parameters of export
of the script sql. Hour is possible to
establish what to export; moreover it is
possible to decide if to visualize or to
write on disc the content of the generated
script sql. The parameters set up to you come
save to you in the configuration rows.
NEW: Adding of parameters in the configuration
rows; they come saved also the formulations
for the export of the script sql.
UPD: Optimization of the menu main and the menu
popup.
UPD: Added graphical to the Tree object.
UPD: Added the hourglass in the long elaborations.
UPD: Small modifications of the CProject object
and the MainForm.
NEW: Hour it is possible to select and to activate
the menu popup on the labels of the relations
(if visible); moreover the label assumes hour
the same color of the relation line.
UPD: Graphical modifications of the statusbar.
UPD: Reorganization labels of the relations; hour
they come visualized more compressed
regarding the previous version.
UPD: Restructure of the icone of the program.
NEW: The dimensions of the main window hour come
saved in the rows of configuration and
restored to the next start.
UPD: Modernized the window of plan statistics,
with the added one of ulterior information.
NEW: Added one window of selection of the objects
to import from the database in the function
of reverse-engineering.
BUG: Corrected the function of cancellation of the
objects from the menu; hour comes demanded
confirmation before executing the
elimination. Moreover it has been implemented
the verification of the existence of
relations between the present objects in the
plan and the object in cancellation.
UPD: It improves the confirmation messages to you
cancellation.
UPD: Relative modifications to the new version of
Gambas (you see next).
NEW: Program compiled with version 1.9.25 of
Gambas.

Posted by Carlotto Luigi 2006-02-25

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks