* * *

Author Topic: ZMSQL  (Read 5556 times)

scons

  • Full Member
  • ***
  • Posts: 130
ZMSQL
« on: October 24, 2017, 01:58:35 pm »
Hi all,

I see on the Wiki of ZMSQL that there is an updated version (0.1.20) but it is not available in the download link nor in the Online Package Manager (1.8.0RC5).

Is this available somewhere else ?

Thanks
Windows 10-64bit Lazarus 1.8.2 + FPC 3.0.4

tatamata

  • Hero Member
  • *****
  • Posts: 652
    • ZMSQL - SQL enhanced in-memory database
Re: ZMSQL
« Reply #1 on: November 02, 2017, 04:10:24 pm »
Edgar Fernando Rodriguez Pacheco (edgarrod71@gmail.com) is working on the new version of ZMSQL.
As far as I know, he had some problems with compiling the package.
You could contact himm dirrectly on e-mail: edgarrod71@gmail.com

scons

  • Full Member
  • ***
  • Posts: 130
Re: ZMSQL
« Reply #2 on: November 11, 2017, 11:00:34 am »
Ok, It is not really super urgent, but I wanted to try the new veriosn since I had some issues with 0.1.19.

Thanks for your reply Mr. tatamata
Windows 10-64bit Lazarus 1.8.2 + FPC 3.0.4

apexcol

  • Jr. Member
  • **
  • Posts: 51
Re: ZMSQL
« Reply #3 on: December 29, 2017, 04:21:54 am »
Edgar finished his duty for this year, now it has improvements... executable size is lighter and queries are a little faster.  ;)

It has new functions like AddRecord and a better Post on the memory dataset.  you can find all improvements on every edgarrod71@gmail.com comment.  Some I forgot to put.  I'm so sorry for documentation, I hate to document.  Any questions, feel free to contact.   :)

In next message I'll pass the source code...

apexcol

  • Jr. Member
  • **
  • Posts: 51
Re: ZMSQL
« Reply #4 on: December 29, 2017, 04:24:29 am »
***************** SOURCE CODE ************** in attachment, of course :)

wp

  • Hero Member
  • *****
  • Posts: 4727
Re: ZMSQL
« Reply #5 on: December 29, 2017, 10:01:04 am »
To anybody interested in checking out this package, before waisting your time: This is a CodeTyhon version, it will not compile with Lazarus.
Lazarus trunk / fpc 3.0.4 / all 32-bit on Win-10

apexcol

  • Jr. Member
  • **
  • Posts: 51
Re: ZMSQL
« Reply #6 on: December 29, 2017, 10:30:45 am »
Don't be so rude, nor so discriminatorial! :P .

I tested this code on Lazarus also, :P


wp

  • Hero Member
  • *****
  • Posts: 4727
Re: ZMSQL
« Reply #7 on: December 29, 2017, 10:48:16 am »
What is rude in my response? Sorry if you feel offended. But the package does NOT compile with Lazarus:
  • the package has the extension .ctpkg, Lazarus uses .lpk -> I renamed it to lpk, ok - maybe not needed.
  • the package uses other packages not in the standard Lazarus distribution:
      - lz_dbexport --> replace it by lazdbexport
      - lz_sdf --> replace it by lazSDF
      - lz_sqldb --> replace it by SQLDBLaz
      - adFCL --> no idea what this is... Tried to use the standard FCL, but this is already contained.
  • trying to compile: --> error
Quote
Compile package pl_zmsql 6.0.1: Exit code 1, Errors: 1, Warnings: 2
Warning: windres: can't open file `TOQBLinkForm': No such file or directory
Warning: windres: preprocessing failed.
QBLnkFrm.pas(58,0) Error: Error while compiling resources -> Compile with -vd for more details. Check for duplicates.

This is when I gave up.


Lazarus trunk / fpc 3.0.4 / all 32-bit on Win-10

Soner

  • New member
  • *
  • Posts: 30
Re: ZMSQL
« Reply #8 on: December 29, 2017, 02:25:45 pm »
Nice to see that you integrated my changes to jansql so they aren't lost.
Tatamata made great job with zmsql but zmsql can be much more faster at least 2 or 4x.
He copies the results(TjanRecordXYZ) from jansql to tbuffereddataset.
JanSql is very fast, when JanSql can create tbuffeddataset without TjanRecordLists it would be fast.
I am thinking to separate JanSql/zmsql to engine (tdatabase) , ttable, tsql like bde. But I am very busy at moment.

JuhaManninen

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3392
  • I like bugs.
Re: ZMSQL
« Reply #9 on: December 29, 2017, 05:08:01 pm »
I tested this code on Lazarus also, :P
How exactly did you test it? I also want to know.

taazz

  • Hero Member
  • *****
  • Posts: 5136
Re: ZMSQL
« Reply #10 on: December 29, 2017, 05:18:05 pm »
doesn't Avra has a tool that converts from typhoon to lazarus package? I think its called ct2laz that should get you started but if my magic ball works correctly (they do have a temper the freaking things) the message posted by WP seems to intigate that the package depends on some sort of port of the Open Query Builder to lazarus or something along those lines.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

wp

  • Hero Member
  • *****
  • Posts: 4727
Re: ZMSQL
« Reply #11 on: December 29, 2017, 06:46:06 pm »
It compiles now and can be installed. It was the extension of the form files which had to be renamed to .lfm (was: .frm).

[EDIT] Now with simple demo taken from the old CCR version.
« Last Edit: December 29, 2017, 08:15:32 pm by wp »
Lazarus trunk / fpc 3.0.4 / all 32-bit on Win-10

apexcol

  • Jr. Member
  • **
  • Posts: 51
Re: ZMSQL
« Reply #12 on: December 29, 2017, 07:06:12 pm »
Not installing it but using the units...

may another tool help you?  https://forum.lazarus.freepascal.org/index.php/topic,28897.15.html

apexcol

  • Jr. Member
  • **
  • Posts: 51
Re: ZMSQL
« Reply #13 on: December 30, 2017, 02:21:30 am »
Here, exclusive for Lazarus users (those that don't want to modify nothing... ;) )

Go to the project site and download TZMSQL (latest version), then download this file and
Unzip this file inside the directory, there's a lpk file.  Compile, install, enjoy.

tatamata

  • Hero Member
  • *****
  • Posts: 652
    • ZMSQL - SQL enhanced in-memory database
Re: ZMSQL
« Reply #14 on: December 30, 2017, 08:02:37 am »
Great job, apexcol!
Can somebody put this version (ver 1.20.1) to the Lazarus CCR (https://sourceforge.net/projects/lazarus-ccr/files/zmsql/)?

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus