Recent

Author Topic: New to this. Is this possible using Lazarus?  (Read 677 times)

HoosierDaddy

  • Newbie
  • Posts: 3
New to this. Is this possible using Lazarus?
« on: December 02, 2022, 09:57:53 am »
Hi everyone

I'm new here.  I used to be a VB and classic asp developer.
I'm retired now due to health reasons, but I have a friend I'm helping develop a website for.

The website is for a diner. The website has a database that stores menu items and descriptions as well as prices, etc.

My friend wants to be able to use a standard windows app exe to update the database stored on the webhost which is a Linux server running Apache and mySql and Postgress as well as SQL lite.

So I just need to be able to develop a standard windows program with data controls that will allow him to edit the menu items. Via http of course.
.Is it possible to connect to the database with the data source connection?

Do I need any special controls or?

Please take it easy on me.  It's been awhile since I've written any code.
Lasurua just looks cool for fun apps I would write for utilities, etc.  Wondering if it's even feasible to do with Lazuris. 

I know I could do it in PHP, but he hates web interfaces for some reason.
.Thanks in advance. 
Tim.  :D

KodeZwerg

  • Hero Member
  • *****
  • Posts: 2006
  • Fifty shades of code.
    • Delphi & FreePascal
Re: New to this. Is this possible using Lazarus?
« Reply #1 on: December 02, 2022, 10:03:21 am »
Here you can read a little about MySQL and its usage in Lazarus.
I hope it helps you getting started.
« Last Edit: Tomorrow at 31:76:97 xm by KodeZwerg »

Чебурашка

  • Hero Member
  • *****
  • Posts: 566
  • СЛАВА УКРАЇНІ! / Slava Ukraïni!
Re: New to this. Is this possible using Lazarus?
« Reply #2 on: December 02, 2022, 12:37:38 pm »
Hi everyone

I'm new here.  I used to be a VB and classic asp developer.
I'm retired now due to health reasons, but I have a friend I'm helping develop a website for.

The website is for a diner. The website has a database that stores menu items and descriptions as well as prices, etc.

My friend wants to be able to use a standard windows app exe to update the database stored on the webhost which is a Linux server running Apache and mySql and Postgress as well as SQL lite.

So I just need to be able to develop a standard windows program with data controls that will allow him to edit the menu items. Via http of course.
.Is it possible to connect to the database with the data source connection?

Do I need any special controls or?

Please take it easy on me.  It's been awhile since I've written any code.
Lasurua just looks cool for fun apps I would write for utilities, etc.  Wondering if it's even feasible to do with Lazuris. 

I know I could do it in PHP, but he hates web interfaces for some reason.
.Thanks in advance. 
Tim.  :D

Question: this hypothetical desktop app is supposed to connect directly to the DB or do you want it to interact with some http api exposed using apache?

In first case consider that sqlite is not a client/server db so your app must run on the server to access your sqlite db.

In second case you are simply accessing a http exposed api, so all you need is the fcl-web package.
« Last Edit: December 02, 2022, 01:21:49 pm by tt »
FPC 3.2.0/Lazarus 2.0.10+dfsg-4+b2 on Debian 11.5
FPC 3.2.2/Lazarus 2.2.0 on Windows 10 Pro 21H2

HoosierDaddy

  • Newbie
  • Posts: 3
Re: New to this. Is this possible using Lazarus?
« Reply #3 on: December 02, 2022, 01:36:20 pm »

Thank you so much.  I will check it out.
Tim

Hi everyone

I'm new here.  I used to be a VB and classic asp developer.
I'm retired now due to health reasons, but I have a friend I'm helping develop a website for.

The website is for a diner. The website has a database that stores menu items and descriptions as well as prices, etc.

My friend wants to be able to use a standard windows app exe to update the database stored on the webhost which is a Linux server running Apache and mySql and Postgress as well as SQL lite.

So I just need to be able to develop a standard windows program with data controls that will allow him to edit the menu items. Via http of course.
.Is it possible to connect to the database with the data source connection?

Do I need any special controls or?

Please take it easy on me.  It's been awhile since I've written any code.
Lasurua just looks cool for fun apps I would write for utilities, etc.  Wondering if it's even feasible to do with Lazuris. 

I know I could do it in PHP, but he hates web interfaces for some reason.
.Thanks in advance. 
Tim.  :D

Question: this hypothetical desktop app is supposed to connect directly to the DB or do you want it to interact with some http api exposed using apache?

In first case consider that sqlite is not a client/server db so your app must run on the server to access your sqlite db.

In second case you are simply accessing a http exposed api, so all you need is the fcl-web package.

HoosierDaddy

  • Newbie
  • Posts: 3
Re: New to this. Is this possible using Lazarus?
« Reply #4 on: December 02, 2022, 01:38:47 pm »
Hi. 

Yes, it needs to connect directly to the DB and that way can update, delete, etc.  Crud app.  Lazuris would provide the front end to the DB only.
Thanks.
Tim



Thank you so much.  I will check it out.
Tim

Hi everyone

I'm new here.  I used to be a VB and classic asp developer.
I'm retired now due to health reasons, but I have a friend I'm helping develop a website for.

The website is for a diner. The website has a database that stores menu items and descriptions as well as prices, etc.

My friend wants to be able to use a standard windows app exe to update the database stored on the webhost which is a Linux server running Apache and mySql and Postgress as well as SQL lite.

So I just need to be able to develop a standard windows program with data controls that will allow him to edit the menu items. Via http of course.
.Is it possible to connect to the database with the data source connection?

Do I need any special controls or?

Please take it easy on me.  It's been awhile since I've written any code.
Lasurua just looks cool for fun apps I would write for utilities, etc.  Wondering if it's even feasible to do with Lazuris. 

I know I could do it in PHP, but he hates web interfaces for some reason.
.Thanks in advance. 
Tim.  :D

Question: this hypothetical desktop app is supposed to connect directly to the DB or do you want it to interact with some http api exposed using apache?

In first case consider that sqlite is not a client/server db so your app must run on the server to access your sqlite db.

In second case you are simply accessing a http exposed api, so all you need is the fcl-web package.

egsuh

  • Hero Member
  • *****
  • Posts: 1266
Re: New to this. Is this possible using Lazarus?
« Reply #5 on: December 02, 2022, 05:30:07 pm »
It is quite clear that you can do it with Lazarus. But some issues need to be checked.

If the front end application is to be run on the same PC that have databases, it is quite simple.

But you said http connection. In this case, you need two programs --- web-server / web service server,  and the front end application. I do not have experience in webservice with Lazarus.

In this case, front end application works like a web browser (sending requests to and receiving response from webserver). Lazarus has features to do that.

It would not be easy to directly link to databases over http from front end --- someone mentioned RealThinClient. 

 

TinyPortal © 2005-2018