Recent

Author Topic: LazSqlX  (Read 110504 times)

flamer0n

  • Guest
LazSqlX
« on: September 16, 2013, 12:25:42 pm »
LazSqlX is a Multiplatform  mini sql Manager built completely with Lazarus FPC. It comes in handy to any developer who works with MsSQL, Oracle, MySql,Sqlite or Firebird. It provides them with an intuitive database management tool that can be used to browse the database structure, generate and execute queries and stored procedures, view table information and create new tables. I think it's important to let you know that because of security reasons I'm only sharing Softpedia download link so you can be assured that it has passed the 100% Clean from Softpedia .


Free Download

Softpedia:
http://www.softpedia.com/get/Internet/Servers/Database-Utils/LazSqlX.shtml

Get latest from SourceForge:

LazSqlX Sourceforge

Greets!
« Last Edit: September 11, 2014, 01:48:28 pm by flamer0n »

CaptBill

  • Sr. Member
  • ****
  • Posts: 435
Re: LazSqlX
« Reply #1 on: September 16, 2013, 12:42:36 pm »
Hi,
Is there a linux version available? I only see a Windows download.

Thanks

flamer0n

  • Guest
Re: LazSqlX
« Reply #2 on: September 16, 2013, 12:54:40 pm »
HI @CaptBill,

I just managed to build it in Kubuntu but it has some heavy issues so for now it's unusable for Linux that's why I didn't publish it yet, but I'm working on it.

Thanks

sin_dragan

  • Full Member
  • ***
  • Posts: 127
Re: LazSqlX
« Reply #3 on: September 17, 2013, 10:53:11 am »
I've tested with MsSql, Oracle and Sqlite3 DB, works nice :)

I have to ask, which connection components did you use, I see that query with oracle works, I had some troubles with executing query in Laz.

Thanks and keep up the good work.

EDIT: I see it's Zeos for OracleDB.
« Last Edit: September 17, 2013, 05:02:29 pm by sin_dragan »
Windows 7 64 bit
Lazarus 1.4.1 (w/fixes) FPC 2.6.4 win32

flamer0n

  • Guest
Re: LazSqlX
« Reply #4 on: September 18, 2013, 12:00:21 pm »
@sin_dragan Hi dragan! Thank you!
  Yes you're right, I used Zeos components. For Oracle, in database property of zconnection I put the whole server descriptor (same that is in ORA TNS File), I've also included ora light client libs so you don't need Oracle Client installed on client machine. Installed files can also be packed into a zip and it will work, you can take it with you in your usb stick memory, especially useful when someone needs to go to some client but has no access to install any sql manager in client's client machine, so one could use this tool to query and browse DBs.

Mike.Cornflake

  • Hero Member
  • *****
  • Posts: 1227
Re: LazSqlX
« Reply #5 on: September 19, 2013, 03:39:42 am »
I've also included ora light client libs so you don't need Oracle Client installed on client machine.

Didn't know you could do that.  That's brilliant :-)  I presume there's no licensing issue from Oracle?

Quote
Installed files can also be packed into a zip and it will work, you can take it with you in your usb stick memory, especially useful when someone needs to go to some client but has no access to install any sql manager in client's client machine, so one could use this tool to query and browse DBs.

Again, superb.  I'm in this exact situation far too often.  I've been using either Portable Database Browser or a variety of smaller tools I've written myself.  I've added your app to my arsenal :-)   Many thanks.
Lazarus Trunk/FPC Trunk on Windows [7, 10]
  Have you tried searching this forum or the wiki?:   http://wiki.lazarus.freepascal.org/Alternative_Main_Page
  BOOKS! (Free and otherwise): http://wiki.lazarus.freepascal.org/Pascal_and_Lazarus_Books_and_Magazines

flamer0n

  • Guest
Re: LazSqlX
« Reply #6 on: September 19, 2013, 09:19:09 am »
@Mike.Cornflake

Quote
Didn't know you could do that.  That's brilliant :-)  I presume there's no licensing issue from Oracle?

I don't know about licensing, but I'm not selling anything so I shouldn't be worried :) , I think it's just as same as downloading those libs from the internet which is free and no restrictions at all.

Enjoy!

ps.
I'll be adding more stuff to it later, like cloning db structure from one db platform to another one, (ie from MsSql to MySql or Oracle and vice versa)

 




 

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #7 on: September 19, 2013, 09:25:28 am »
I have to ask, which connection components did you use, I see that query with oracle works, I had some troubles with executing query in Laz.
Please don't hesitate to start a forum thread about those troubles - if we can improve Oracle support in SQLDB, we'd be happy to...
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

flamer0n

  • Guest
Re: LazSqlX
« Reply #8 on: September 19, 2013, 04:35:02 pm »
I just uploaded new version

3.16.1

-Fixed a bug  for MsSql mode, when opening TableData wouldn’t allow editing data in the grid

-Fixed a bug where copy rows didn’t copy data properly if they contained GUID fields (MsSql)

SouceForge
https://sourceforge.net/projects/lazsqlx/files/Version%203.16.1.1145/

I just sent Softpedia a request for new version, I hope they update it soon.

ps.
Zeos Components don't handle GUID properly, so I had to work-around to get guid as string.


esvignolo

  • Full Member
  • ***
  • Posts: 144
  • Using FPC in Windows, Linux, Macos
Re: LazSqlX
« Reply #9 on: September 19, 2013, 04:58:45 pm »
Hi flamer0n, i want to make a suggestion, ini configuration file, to work better platform, and also run without elevation of permissions in windows 7/8 would be better left in the appdata directory, I pass a code sample:
Code: [Select]
procedure TfrmMain.LoadConfig; 
var
  Archivo: TINIFile;
begin
  Archivo := TINIFile.Create(IncludeTrailingPathDelimiter(GetAppConfigDirUTF8(False)) +
    'LazSqlX.ini');                   
......

end;

Finally, maybe if u can release the code, we can contribute :).

Thanks for your effort!


edit: surrounding code, thanks to BigChimp :) for the suggestion, and for contributing to fpc / lazarus the 25 hours of the day :)
« Last Edit: September 19, 2013, 05:29:57 pm by esvignolo »

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #10 on: September 19, 2013, 05:20:49 pm »
Hi flamer0n, i want to make a suggestion, ini configuration file, to work better platform, and also run without elevation of permissions in windows 7/8 would be better left in the appdata directory, I pass a code sample:

procedure TfrmMain.LoadConfig; 
var
  Archivo: TINIFile;
begin
  Archivo := TINIFile.Create(IncludeTrailingPathDelimiter(GetAppConfigDirUTF8(False)) +
    'LazSqlX.ini');                   
......

end;
Good idea. One addition: you could first try to read the ini from the current dir so you can use an ini file with settings on USB sticks etc, then read from GetAppConfigDirUTF8 and override with that one if found.

@esvignolo: next time you post, you may look into surrounding code snippets with code tags (see the button marked # on the editor toolbar)... that makes the code much more readable ;) e.g.:

Code: [Select]
procedure TfrmMain.LoadConfig; 
var
  Archivo: TINIFile;
begin
  Archivo := TINIFile.Create(IncludeTrailingPathDelimiter(GetAppConfigDirUTF8(False)) +
    'LazSqlX.ini');                   
......

end;
Finally, maybe if u can release the code, we can contribute :).
Yes, that would be very nice!

Thanks for your effort!
Thanks from me as well, glad to see more Laz db programs ;)
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

flamer0n

  • Guest
Re: LazSqlX
« Reply #11 on: September 19, 2013, 06:38:26 pm »
Thank you so much guys! I thought of releasing the code, but before I do that I must remove some functionality as they are considered know-hows of the company I work in, some portions of code are used in commercial products. 
 I just hope you understand

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #12 on: September 20, 2013, 08:57:57 am »
Of course. Good luck & thanks.
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

sin_dragan

  • Full Member
  • ***
  • Posts: 127
Re: LazSqlX
« Reply #13 on: September 22, 2013, 09:59:20 am »
I have to ask, which connection components did you use, I see that query with oracle works, I had some troubles with executing query in Laz.
Please don't hesitate to start a forum thread about those troubles - if we can improve Oracle support in SQLDB, we'd be happy to...

My mistake, this problem has been reported and it's related to Lazarus 1.0.8.

Quote
Oracle 12g Express
NAME VALUE$
------------------------------ ----------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

I am able to set SQLQuery.Active := true in the Object Inspector in Lazarus 1.0.6 / FPC 2.6.0.

This doesn't work in Lazarus 1.0.8 and up with FPC 2.6.2.

Thanks for looking into this issue.
Windows 7 64 bit
Lazarus 1.4.1 (w/fixes) FPC 2.6.4 win32

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #14 on: September 22, 2013, 10:18:27 am »
My mistake, this problem has been reported and it's related to Lazarus 1.0.8.

Quote
Oracle 12g Express
NAME VALUE$
------------------------------ ----------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

I am able to set SQLQuery.Active := true in the Object Inspector in Lazarus 1.0.6 / FPC 2.6.0.

This doesn't work in Lazarus 1.0.8 and up with FPC 2.6.2.
Ah, that looks like bug 24723: OracleConnection: ORA-01062: unable to allocate memory for define buffer

As I cannot reproduce that bug, it would help a lot if you could try on FPC trunk+Lazarus (say Lazarus trunk) and see if the bug is still present there. If you do so, please report your findings in the bug tracker...
I'd also be happy to try and respond on the forum though starting a different thread may be appropriate ;)
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified