Hi,

I have been using Dezign for Database v2.5.2 for years, but it's getting a bit dated now. I know newer versions exist, but it's rather expensive.

http://opensoft.homeip.net/~graemeg/dezign_for_databases.png

Has anybody created something like this using Lazarus, or even thought about creating something like this. I think it will be a nice future extension to Lazarus Data Desktop.

What software do you guys use to design your databases? Yes I know I can use gEdit, Notepad and pen & paper, but what's the fun in that. Doing it visually is so much easier, quicker etc.. The nice thing about Dezign for Databases is that one database design can be used to generate create scripts for various databases (Oracle, MySQL, MS-Acces, Interbase, etc..) plus you can tweak the supported definitions and types for each DB backend. This is how I managed to stretch v2.5.2 for so many years, even though it doesn't even know about Firebird DB. :-)

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

It is planned, but it is one thing among many.

What software do you guys use to design your databases? Yes I know I can use gEdit, Notepad and pen & paper, but what's the fun in that.

For firebird, I use IBAdmin (now called Firebird & Interbase studio) since years:
http://www.sqlly.com
very good, but commercial. There is even a linux version (created at my request, many years ago, in Kylix)

Well, the lazarus data desktop is meant just to do this kind of thing
- just create a Data dictionary - but it lacks a visual interface. All data structures are there, there is code to make a diff between 2 databases and whatnot. The visual interface is the last thing that is needed.

Michael.

Hello,

some time ago I started working on a simple ORM-Mapper for Freepascal and SQLite. Sadly this project is miles away from a stable point.

But one part will be the design process. I want to write an import method for .dia-files, extract the UML class model and generate Lazarus classes, mapping methods and database tables.
Maybe a similar system would be easier to write than a visual designer?

mfg
Michael

I use IBExpert personal edition. Bar none the best Firebird Admin tool available, IMO.

2009/5/28 Lee Jenkins :

I use IBExpert personal edition. ?Bar none the best Firebird Admin tool available, IMO.

Even better that 'isql'? That will be impressive! ;-)

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

Except if you have large databases (lots of tables and other objects, think order of magnitude 1500), it's GUI is totally unworkable then :(

Michael.

2009/5/28 Michael Van Canneyt :

It is planned, but it is one thing among many.

Ah, one can dream. :-)

For firebird, I use IBAdmin (now called Firebird & Interbase studio) since years:

And it's half the price of Dezign for Databases. Though Design does support a few more database backends and by the looks of it a few more features. I guess you pay for what you get. :)

Dezign supported databases:
Oracle, MS SQL Server, MySQL, IBM DB2, Firebird, InterBase, MS Access, PostgreSQL, Paradox, dBase, Pervasive, Informix, Clipper, Foxpro, Sybase, SQLite, ElevateDB, NexusDB, DBISAM and more...

Needless to say, an impressive list.

Well, the lazarus data desktop is meant just to do this kind of thing - just create a Data dictionary - but it lacks a visual interface. All data structures are there, there is code to make a diff between 2 databases and whatnot.

Impressive. It imported by database structure into the data dictionary. With a few mistakes, but nothing major.

It seems to also have the ability to generate CREATE TABLE statements, but unfortunately the GUI interface limits you to one table at a time.

In the mean time, I'm fixing a few other issues with LazDataDesktop. I'll submit my patches shortly into Mantis.

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

2009/5/28 Michael Van Canneyt :

Except if you have large databases (lots of tables and other objects, think order of magnitude 1500), it's GUI is totally unworkable then :(

That's where Dezign v3 and up is also very nice. You can create multiple "sub-views" of your database, because larger than 50+ tables it's just impossible to fit everything on one screen/view. So we have multiple views into our data. Debtors View, User View, Security View etc... which all only show a sub-set of the tables relating to that view.

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

I use Database Workbench Pro which works okay for me. Commercial sadly. http://www.upscene.com/products.dbw.index.php
They do a free "lite" version which I have not tried

Interesting. I've never used IBExpert much any serious querying so I have never experienced that but I'll look out for it, thanks. I just use it primarily for development.

For querying the database ad hoc, been preferring to use flamerobin which is very fast and limits a lot of the gui stuff from what I can tell and it's getting better (functionality) to the point where I'll probably switch to it exclusively before too long.

Graeme: Its cross platform as well. But again, its firebird only obviously.

http://www.flamerobin.org/

"Leonardo M. Ram?" wrote

About FlameRobin. It is developed using FPC/Lazarus?. It caught my attention because in the site it says it works on Solaris.

It uses C++ and wxWidgets

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20090528/831c2c1f/attachment.html>

About FlameRobin. It is developed using FPC/Lazarus?. It caught my attention because in the site it says it works on Solaris.

BTW, I use IBExpert and I love its Stored Procedure Debugger.

Leonardo M. Ram?
Griensu S.A. - Medical IT C?rdoba
Tel.: 0351 - 4247979

Lee Jenkins escribi?:

Sorry. It's a C++ app.

Leonardo M. Ram?
Griensu S.A. - Medical IT C?rdoba
Tel.: 0351 - 4247979

Leonardo M. Ram? escribi?:

-

DBDESIGNER -made with delphi -its free (source code available)
- MySQL Workbench 5.0 is based on DBDesigner
alex..

http://fabforce.net/dbdesigner4/downloads.php

2009/5/28 Lee Jenkins :

Graeme: Its cross platform as well. ?But again, its firebird only obviously.

I have been using FlameRobin for 2 years already - only for executing queries while I develop. Recently I tried to switch to Lazarus Data Desktop for that, though LazDataDesktop still needs some work.

For table design, I still continue to use "Dezign for Databases". I don't mind if the tool is Windows only, as long as it's not based on .NET, I can normally run them without problems or effort via WINE.

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

2009/5/29 Alex Kovacic :

DBDESIGNER -made with delphi -its free (source code available) ?- MySQL Workbench 5.0 is based on DBDesigner alex..

Thanks, I'll take a look.

I just found out that "Dezign for Database" is also created with Delphi. :-) It seems quality DB tools are mostly developed with Delphi. Cool. ;-)

Regards,
- Graeme -

_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/

Dears people:

I need to apply Pitagoras theorem but I found some difficulties with FP in get the power of a number.

I use x ** y (x as base and y as power) but the fp indicates and overload.

I will appreciate any help.

yours,

Ing. H?ctor F. Fiandor

---------------------------------------
Red Telematica de Salud - Cuba
CNICM - Infomed

H?ctor Fiandor Rosario ha scritto:

use sqr(x) to get x^2 or pow(x,2) in unit math
and sqrt to get the rsquare

Well, in that case I strongly encourage you to check out IBExpert. The personal edition is free and has all but the most advanced features included. For Firbird DB design, I think its hard to beat.

IMHO It is beaten easily by IBAdmin, for instance, but this is largely a matter of taste, although I think I could present some objective criteria. :)

Michael.

For firebase!
IBEasy 1.5.2

Dear Mr. Coppola:

really I solve using this:

var valor1,valor2,valor3:integer;
valor3:=round(power(valor1,valor2));

and declaring the unit "math" in uses.

Thanks very much

Ing. H?ctor F. Fiandor

---------------------------------------
Red Telematica de Salud - Cuba
CNICM - Infomed

That is fine if raising to an integer power, but if not:

Result := exp((ln(x) * y);

Will give you the correct value for non integer powers. Ok, there is a small error which is insignificant for all practical purposes.

I guess I am wrong, both ways can raise to a non integer power.

thanks very much

Ing. H?ctor F. Fiandor

Dear sirs:

some time ago a see a program in a diskette, that if the user wants to copy to another memory (the PC hard disk, for example) then was copy but was erased in the diskette, and the same in the other way.

I want to know if somebody knows about this.

thanks in advance,

yours,

Ing. H?ctor F. Fiandor

---------------------------------------
Red Telematica de Salud - Cuba
CNICM - Infomed

Sounds like a bug. ;)

I want to know if somebody knows about this.

Mattias

Some time ago I saw a diskette but now is hard to find one ... ;)

Boguslaw

Hello Lazarus,

Sunday, June 14, 2009, 3:35:20 AM, you wrote:

HFR> some time ago a see a program in a diskette, that if the user wants to copy HFR> to another memory (the PC hard disk, for example) then was copy but was HFR> erased in the diskette, and the same in the other way. HFR> I want to know if somebody knows about this.

That was an old protect method, if you copy the program with regular methods (copy) the new copy was not protected and refuses to run. If you want to copy the protection you must use the built in copy method which in fact was a regular copy followed by a destroy diskette protection and create the same protection in the new media.

This kind of protection was useless since protected mode operative systems, which does not provide direct access to the mass storage media without low level driver.

A cheap way to do this is to use a license key file which is is hidden, so your copy procedure will take care of it, but not the very basic users. Other way is to crypt pieces of your EXE using serial number of your media, your copy procedure will kill the original license key and generate the new one in the new media, but this will not prevent your software to be running in two, three, n, bit copied USB memories in example.

Ah,you want cheap software protection.I saw something like this - turning ordinary USB memory aka flash disk into dongle.

Boguslaw

Dear JoshyFun:

thanks very much for your explanation.

yours,

Ing. H?ctor F. Fiandor

---------------------------------------
Red Telematica de Salud - Cuba
CNICM - Infomed