Recent

Author Topic: ExtPascal and database  (Read 2124 times)

cappe

  • Full Member
  • ***
  • Posts: 158
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: 3207
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
Turbo Pascal v1 on CCP/M-86, multitasking with LAN and 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: 10912
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 »
The average programmer productivity is 4-5 hours per day. Peak performance 72 hours for short bursts. MTBF is 1 second or less.

MarkMLl

  • Hero Member
  • *****
  • Posts: 3207
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
Turbo Pascal v1 on CCP/M-86, multitasking with LAN and 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: 10912
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 »
The average programmer productivity is 4-5 hours per day. Peak performance 72 hours for short bursts. MTBF is 1 second or less.

Thaddy

  • Hero Member
  • *****
  • Posts: 10912
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.
The average programmer productivity is 4-5 hours per day. Peak performance 72 hours for short bursts. MTBF is 1 second or less.

MarkMLl

  • Hero Member
  • *****
  • Posts: 3207
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
Turbo Pascal v1 on CCP/M-86, multitasking with LAN and 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: 3384
  • 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: 599
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

  • Full Member
  • ***
  • Posts: 130
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: 599
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