Recent

Author Topic: ExtPascal and database  (Read 3507 times)

cappe

  • Full Member
  • ***
  • Posts: 191
ExtPascal and database
« on: September 28, 2021, 06:30:59 pm »
Anyone have an example of how to create a database application with extpascal? Making a menu?

MarkMLl

  • Hero Member
  • *****
  • Posts: 6676
Re: ExtPascal and database
« Reply #1 on: September 28, 2021, 06:48:06 pm »
Anyone have an example of how to create a database application with extpascal? Making a menu?

What's extpascal?

MarkMLl
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

Thaddy

  • Hero Member
  • *****
  • Posts: 14201
  • Probably until I exterminate Putin.
Re: ExtPascal and database
« Reply #2 on: September 28, 2021, 07:06:43 pm »
It is an ExtJs wrapper. The FPC JVM target works nicely with it and databases, so I guess he will need a FPC JVM build. That supports most Db functionalty, including SqlDb and engines at the standard FPC RTL level. Most, if not all - non-gui examples drom FPC fcl-db simply work on the java target. ExtJs can be used for a GUI.
Pas2Js has exanples for it.
« Last Edit: September 28, 2021, 07:28:15 pm by Thaddy »
Specialize a type, not a var.

MarkMLl

  • Hero Member
  • *****
  • Posts: 6676
Re: ExtPascal and database
« Reply #3 on: September 28, 2021, 08:12:32 pm »
OK, sorry and thanks for the clarification: I wasn't sure whether it was directly relevant to FPC.

MarkMLl
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

Thaddy

  • Hero Member
  • *****
  • Posts: 14201
  • Probably until I exterminate Putin.
Re: ExtPascal and database
« Reply #4 on: September 28, 2021, 09:32:49 pm »
OK, sorry and thanks for the clarification: I wasn't sure whether it was directly relevant to FPC.

MarkMLl
It should be possible to use native cpu code through JNI but I never tried that.
The tools for it are available with Pas2Js.
« Last Edit: September 28, 2021, 09:36:12 pm by Thaddy »
Specialize a type, not a var.

Thaddy

  • Hero Member
  • *****
  • Posts: 14201
  • Probably until I exterminate Putin.
Re: ExtPascal and database
« Reply #5 on: September 28, 2021, 09:42:32 pm »
These features are a bit under advertised...Jonas and Mattias have created something special.
Specialize a type, not a var.

MarkMLl

  • Hero Member
  • *****
  • Posts: 6676
Re: ExtPascal and database
« Reply #6 on: September 28, 2021, 09:54:05 pm »
These features are a bit under advertised...Jonas and Mattias have created something special.

As is their wont :-)

MarkMLl
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

PascalDragon

  • Hero Member
  • *****
  • Posts: 5446
  • Compiler Developer
Re: ExtPascal and database
« Reply #7 on: September 29, 2021, 08:59:11 am »
It is an ExtJs wrapper. The FPC JVM target works nicely with it and databases, so I guess he will need a FPC JVM build. That supports most Db functionalty, including SqlDb and engines at the standard FPC RTL level. Most, if not all - non-gui examples drom FPC fcl-db simply work on the java target. ExtJs can be used for a GUI.
Pas2Js has exanples for it.

Ehm... FPC JVM <> pas2js. The former is the port for the Java Virtual Machine the later transpiles to JavaScript which are two different languages. And the former definitely does not support SqlDb.

devEric69

  • Hero Member
  • *****
  • Posts: 648
Re: ExtPascal and database
« Reply #8 on: September 29, 2021, 10:39:13 am »
For info., there's a specially dedicated discussion thread here, concerning ExtPascal: https://forum.lazarus.freepascal.org/index.php/topic,8106.msg419488.html#msg419488.
AMHO, using the fpWeb + SqlDb [backend side] + pas2js  [frontend side] frameworks seems the more academic \ canonical solution, from the point of view of the official maintainers \ developers of fpc + Lazarus.
use: Linux 64 bits (Ubuntu 20.04 LTS).
Lazarus version: 2.0.4 (svn revision: 62502M) compiled with fpc 3.0.4 - fpDebug \ Dwarf3.

PierceNg

  • Sr. Member
  • ****
  • Posts: 369
    • SamadhiWeb
Re: ExtPascal and database
« Reply #9 on: September 29, 2021, 11:13:59 am »
According to https://github.com/farshadmohajeri/extpascal, last code commit > 10 years ago, license is  GPL.

ExtPascal may not work with the ExtJS of today. You'll have to hunt down an old compatible version.  Or try to make it work with current ExtJS, which is commercial with 30-day free trial.

I suggest better look into pas2js.

devEric69

  • Hero Member
  • *****
  • Posts: 648
Re: ExtPascal and database
« Reply #10 on: September 29, 2021, 11:30:52 am »
ExtPascal may not work with the ExtJS of today.

Indeed, this is very possible: AFAIK, the ExtJS editor only keeps track (to be downloaded) of its few latest javascript engines on the internet. So, ExtPascal (the Pascal backend driving code for ExtJS fontend javascipt engine) should work, but with a 10 years old and specific ExtJS javascript versioned engine (some people create \ historize their own backups of their own ExtJS version, on Github for example). Nevertheless, this is not the policy pursued by the ExtJS editor itself...

I suggest better look into pas2js.

I give the same advice (take a look at pas2js), in the interests of the stability (for the future of your projects).
« Last Edit: September 29, 2021, 11:32:57 am by devEric69 »
use: Linux 64 bits (Ubuntu 20.04 LTS).
Lazarus version: 2.0.4 (svn revision: 62502M) compiled with fpc 3.0.4 - fpDebug \ Dwarf3.

 

TinyPortal © 2005-2018