Forum > Networking and Web Programming

New to this. Is this possible using Lazarus?

(1/2) > >>

HoosierDaddy:
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:
Here you can read a little about MySQL and its usage in Lazarus.
I hope it helps you getting started.

tt:

--- Quote from: HoosierDaddy 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

--- End quote ---

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:

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


--- Quote from: tt on December 02, 2022, 12:37:38 pm ---
--- Quote from: HoosierDaddy 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

--- End quote ---

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.

--- End quote ---

HoosierDaddy:
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



--- Quote from: HoosierDaddy on December 02, 2022, 01:36:20 pm ---
Thank you so much.  I will check it out.
Tim


--- Quote from: tt on December 02, 2022, 12:37:38 pm ---
--- Quote from: HoosierDaddy 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

--- End quote ---

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.

--- End quote ---

--- End quote ---

Navigation

[0] Message Index

[#] Next page

Go to full version