U-Dbu

U-Dbu

Postby Carles » Sun Apr 30, 2023 9:25 am

Hi friends,

U-Dbu is an example program whose objective is to show its functionality and his way of programming. The scenario here will be the web, one of the jumps that most makes it difficult for many of the harbour programmers. After 3 years (COVID confinement) in which I participated in the construction of the mods, I saw that few made the jump and I didn't understand why, since currently modHarbour is analogous in use to php with the same functionalities, but not enough. You have to know also web. All web world: flows, languages (html,js,css + jquerys, bootstrap,...), server management,...In short, a lot of knowledge.

The use of UT (Uhttpd2+TWeb) creates a layer for most of these concepts and allows us to easily create applications like the one I show you here, U-Dbu.

It is a simple application and more features can be added, but most importantly is to be able to check the strength that you can have with this system and see how build an entire application on the web.

All the code is available, you can modify, delete, delete and even use it in your projects.

If you want to participate in the project, create queries, doubts,..., we have a forum in https://discord.gg/bq8a9yGMWh

Join us and start experiencing the new UT concept.

DONWLOAD -> https://github.com/carles9000/u-dbu


Regards.


Charly Aubia
Salutacions, saludos, regards

"...programar es fácil, hacer programas es difícil..."

UT Page -> https://carles9000.github.io/
Forum UT -> https://discord.gg/bq8a9yGMWh
Skype -> https://join.skype.com/cnzQg3Kr1dnk
User avatar
Carles
 
Posts: 1126
Joined: Fri Feb 10, 2006 2:34 pm
Location: Barcelona

Re: U-Dbu

Postby ramirezosvaldo2 » Tue May 09, 2023 6:47 pm

Excelente, Charly, funcionado con DBF locales y en el servidor
y sobre todo que hace todo un GRID apartir de una leer la estructura del DBF

Gracias Chaly
Saludos
ramirezosvaldo2
 
Posts: 58
Joined: Mon Jan 19, 2009 4:40 pm

Re: U-Dbu

Postby Jimmy » Tue May 09, 2023 9:05 pm

hi Charly,
Carles wrote:Join us and start experiencing the new UT concept.

DONWLOAD -> https://github.com/carles9000/u-dbu

i have download and start App.EXE -> Server Harbour9000 was started...
but what to do next ?

sorry i´m a Internet "Dummy", can you help please
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: U-Dbu

Postby Carles » Wed May 10, 2023 5:18 am

Jimmy,

Jimmy wrote: have download and start App.EXE -> Server Harbour9000 was started...
but what to do next ?


Run the server by starting app.exe and then from a browser put the url localhost:81

C.
Salutacions, saludos, regards

"...programar es fácil, hacer programas es difícil..."

UT Page -> https://carles9000.github.io/
Forum UT -> https://discord.gg/bq8a9yGMWh
Skype -> https://join.skype.com/cnzQg3Kr1dnk
User avatar
Carles
 
Posts: 1126
Joined: Fri Feb 10, 2006 2:34 pm
Location: Barcelona

Re: U-Dbu

Postby Jimmy » Wed May 10, 2023 4:24 pm

hi,
Carles wrote:Run the server by starting app.exe and then from a browser put the url localhost:81

thx for Answer

it is so easy ... when know what to do :D
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: U-Dbu

Postby ramirezosvaldo2 » Wed May 10, 2023 5:14 pm

Hello Jimmy

Do you remember xb2net ?

Have you see the web server sample from Boris ?

Then ... UT Project is like WebServer.

Charly has been working some time bring it to harbour.

Actually it is a http server and https server, right now he is working with websockets

Regards
Osvaldo Ramirez
ramirezosvaldo2
 
Posts: 58
Joined: Mon Jan 19, 2009 4:40 pm

Re: U-Dbu

Postby Jimmy » Wed May 10, 2023 6:40 pm

hi Osvaldo
ramirezosvaldo2 wrote:Do you remember xb2net ?

Have you see the web server sample from Boris ?

ah ... yes
i begin to understand

thx
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: U-Dbu

Postby Carles » Thu May 11, 2023 11:40 am

Dear Osvaldo,

ramirezosvaldo2 wrote:Then ... UT Project is like WebServer.


I didn't know about this project and regardless of how it looks like, it's not the same and nor is it a webserver. I took a look at the system xb2 and, for example, the screen design part, which is one of the most complex, it is assumed that you already know how to program web views with html, css and javascript, for example. This has been one of the great handicaps that he could see in recent years in the majority of harbour users trying to make the jump to the web.

When I designed the UT project (based on the last 3 years and thinking only in the harbour key) one of the legs of the chair was the design of screens and for this we used Tweb, which is based on Bootstrap. If you see the example of u-dbu, the appearance of the screens is like a web modern, responsive and above all without touching practically any html, css and javascript, the entire screen is designed practically with commands.

This leg of the design, together with the others, such as the integrated server, api for the management of controls and frontend<->backend interaction and the management of the entire flow of a web application, all all all from harbour, I think makes it an attractive project for user harbour.

C.
Salutacions, saludos, regards

"...programar es fácil, hacer programas es difícil..."

UT Page -> https://carles9000.github.io/
Forum UT -> https://discord.gg/bq8a9yGMWh
Skype -> https://join.skype.com/cnzQg3Kr1dnk
User avatar
Carles
 
Posts: 1126
Joined: Fri Feb 10, 2006 2:34 pm
Location: Barcelona

Re: U-Dbu

Postby ramirezosvaldo2 » Thu May 11, 2023 2:19 pm

I forgot to comment...

There is also TWEB from Charly too is a screen design, routes, sessions,
together with UT they make an excellent dumbbell to have the FRONT and BACK all in one,
this gives a plus to many frameworks.

Worth a look.

Greetings
Osvaldo Ramirez
ramirezosvaldo2
 
Posts: 58
Joined: Mon Jan 19, 2009 4:40 pm

Re: U-Dbu

Postby Maurizio » Fri May 12, 2023 6:49 am

Hello Charly

nice work , my doubt is then if it is possible to install and configure on any apache server ( Linux and Windows ) ?

Thanks Maurizio .
User avatar
Maurizio
 
Posts: 823
Joined: Mon Oct 10, 2005 1:29 pm

Re: U-Dbu

Postby Carles » Fri May 12, 2023 10:23 am

Hi Maurizio,

You don't need apache. The spirit of this project is

Image

If you download the example of U-Dbu you can see that it is an app.exe. This program is the server that manages all your web application. I invite you to try it

You can quickly create real applications for your clients investing very little time.

Image

C.
Salutacions, saludos, regards

"...programar es fácil, hacer programas es difícil..."

UT Page -> https://carles9000.github.io/
Forum UT -> https://discord.gg/bq8a9yGMWh
Skype -> https://join.skype.com/cnzQg3Kr1dnk
User avatar
Carles
 
Posts: 1126
Joined: Fri Feb 10, 2006 2:34 pm
Location: Barcelona

Re: U-Dbu

Postby TimStone » Fri May 12, 2023 6:52 pm

I downloaded this and found it very interesting.

My quick question: It appears that this is a "web server", so it would not be hosted in the cloud. How would some access it via the internet ? I know the browser on the computer where it is running uses localhost:81, but what about the person in another location who wants to access it ?

I did look at the forum setup for it, but everything is in Spanish and translation is possible, but takes a long time and thus I cannot simply browse for answers. I wish that forum had the ability to auto translate.

Thank you.
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2942
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: U-Dbu

Postby Carles » Sat May 13, 2023 7:35 am

Hi Tim,

TimStone wrote:I downloaded this and found it very interesting.


Thanks, I really think it's a good way to make the jump to the web

TimStone wrote:My quick question: It appears that this is a "web server"


It is more than a web server. It is a server prepared so that together with tweb, it works in a certain way to help us create our web applications more quickly and in a different way.

TimStone wrote: so it would not be hosted in the cloud. How would some access it via the internet ? I know the browser on the computer where it is running uses localhost:81, but what about the person in another location who wants to access it ?


Very easy, these are the basic principles of a web application. I will try to be as brief as possible. You have your application on your computer with an internet connection. This computer is assigned a public IP. If you open the port on your router, (here each one would have to learn how to connect to your router to change parameters) then your application will already be accessible from the Internet.

For example, your Public IP (you can know it by connecting to https://whatismyipaddress.com for example) is 87.12.32.66, so from any computer in the world putting 87.12.32.66:81 in the url of a browser would access your website . Easy

These little details are already a bit of web culture and how it works. This is quickly learned. To finish this point, you could assign a domain to your public IP. What does this mean? Give a name to this IP to make it easier to refer to it.

I recommend for its extreme ease to try, for example, to put your ip in https://www.duckdns.org/ which is free and works super well. Let's imagine that you put a name that points to your ip, for example http://bigtim.duckdns.org that points to 87.12.32.66 . Once you have this domain saved, you can write bigtim.duckdns.org:81 from any browser and you will access your website.

I think this could be a first exercise to do

TimStone wrote:I did look at the forum setup for it, but everything is in Spanish and translation is possible, but takes a long time and thus I cannot simply browse for answers. I wish that forum had the ability to auto translate.


I'm sorry that at the moment it is only in English. We started a group of harbor friends and they all spoke in Spanish. In the discord forum https://discord.gg/sqTJY44Yx6 we can add if you want a thread in English


Regards.
C.
Salutacions, saludos, regards

"...programar es fácil, hacer programas es difícil..."

UT Page -> https://carles9000.github.io/
Forum UT -> https://discord.gg/bq8a9yGMWh
Skype -> https://join.skype.com/cnzQg3Kr1dnk
User avatar
Carles
 
Posts: 1126
Joined: Fri Feb 10, 2006 2:34 pm
Location: Barcelona

Re: U-Dbu

Postby reinaldocrespo » Sat May 13, 2023 4:27 pm

Hello Charly;

Interesting indeed. I can see how you can replace your current apps for a local server hosted app that's available via any webbrowser on the LAN. So, instead of having a workstation connect to the server to access your dbfs and have data travel across the wires, you access the server via a browser without having to learn css and javascript which are the two biggies. I think this is a good step forward that opens great possibilities.

However, this will not work on a cloud hosted server as I doubt very much you will be allowed to install a .exe that accepts connections outside of their security configurations. For example, if you want your app hosted on AWS you probably can't install that .exe, or can you?

I plan to delve into your project soon. I think it is a great contribution. Thank you.
User avatar
reinaldocrespo
 
Posts: 979
Joined: Thu Nov 17, 2005 5:49 pm
Location: Fort Lauderdale, FL

Re: U-Dbu

Postby Carles » Sun May 14, 2023 10:17 am

Hello Reinaldo,

I don't really understand what you mean. What you can test with U-Dbu is a real web application, in the same style as when we make windows applications. The only difference is that the scenario is the web. Your web application can be used anywhere in the world with a browser.

Do you know what a server hosted in the cloud is? It's a computer that might be in the next room :D. No jokes, the vast majority of hostings as they are currently conceived and based on the fact that you use shared systems, they do not let you run an exe. However, you can have a dedicated hosting that yes, but…. Why not use yours or any computer that your client has? What problem would there be?

You are giving your client the ability to quickly expand the potential of your application with web modules that can help exponentially scale the functionality of your application. Or maybe I'm wrong?

Can you imagine a Fivewin application working at the same time with another application but on the web sharing the same tables?

It's not really necessary that win-web to coexist but it is an option. The other is to generate applications only in a web environment. I only make available a method with which you can quickly and easily build this type of environment.

C.
Salutacions, saludos, regards

"...programar es fácil, hacer programas es difícil..."

UT Page -> https://carles9000.github.io/
Forum UT -> https://discord.gg/bq8a9yGMWh
Skype -> https://join.skype.com/cnzQg3Kr1dnk
User avatar
Carles
 
Posts: 1126
Joined: Fri Feb 10, 2006 2:34 pm
Location: Barcelona

Next

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 25 guests