Jump to content

mierlp

uniGUI Subscriber
  • Posts

    550
  • Joined

  • Last visited

  • Days Won

    32

mierlp last won the day on December 12 2021

mierlp had the most liked content!

Contact Methods

  • Website URL
    https://www.eventsoft.nl

Profile Information

  • Gender
    Male
  • Location
    WEERT (Netherlands)

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

mierlp's Achievements

Advanced Member

Advanced Member (4/4)

97

Reputation

  1. Hi @stemon63: no matter which platform you go to you will probably have to start all over again. The advantage now of Delphi + uniGUI is that you don't have to learn a 'new language/tool'. In addition, a big advantage now is that you can work visually, e.g. by placing the c omponents on your forms. With most other languages you have to do everything based on code/hmtl/css. Both Microsoft and Google are going to support more WebAssembly. You can see that with .Net6 and Blazor. Blazor has the ability to develop server or client side applications for different platforms with the same code. With client-side, everything is in the local browser which gives you more options to use local devices (I'm told). In the past e.g. a runtime library was used and now it is in the modern browsers. What you actually get now is, -in my opinion, back to square one. Your browser becomes your 'operating system' where you run applications, e.g. via WebAssembly. In fact nothing else than your Windows operating system with a VCL application/Windows program. Windows applications will certainly remain and have great added value because you can't do everything with a web application. E.g. the use of WebAssembly is an answer to that. Besides that you can develop for multiple platforms with one code-base. Because the Windows legacy applications still have a large share you now also see solutions to stream Windows applications to a desktop, so no RPD. Google is already further along with AppStream (https://docs.aws.amazon.com/appstream2/latest/developerguide/what-is-appstream.html) or Move over Windows, Linux apps can now stream to AWS AppStream 2.0 | Windows Central This way you can continue to develop new Windows applications and make them available centrally through the browser. Microsoft does this with App-V but je need a App-V client on you're machine
  2. Hi Fred. I think you mean .NET 6 which will be extended with .NET MAUI. (What is .NET MAUI? - .NET MAUI | Microsoft Docs) You can then write code - in a single project - that delivers a modern client app experience across desktop and mobile operating systems. .NET 6 is an LTS (long term support) release and will be supported for about 3 years. Hope the uniGui roadmap will be updated as well because it's lagging behind quite a bit I am orienting myself to .NET and Blazor though, partly because there are many more third part components compared to uniGUI and is already responsive by default. But then again...nothing is sacred. Every platform has its pros and cons...just depends on what you want to use it for. For now I will make my Windows desktop applications in Delphi and my Event Management software in uniGui. When that is ready we will look further
  3. Hi TsPlus and Thinfinity It is ideal tooling for companies who want to make their Windows application available through the browser. This eliminates the need for the customer to install anything locally. This is often the case with heavy GIS applications for which a web application is not a good alternative. Or companies that are in transition to web to offer it to the customer via browser and in the meantime migrate to a SAAS solution. Web applications are not always feasible, especially when you use a lot of peripherals. Yes it can be done, but not as easily as a Windows client. Also Microsoft still supports ''RDP'' with there new Azure Virtual Desktop...it's more in the direction of VDI from VMware
  4. Hi To make VCL applications available through the browser, https://tsplus.net is a very good alternative. I have used it myself for a number of years to make VCL applications available over the web via a large Delphi application. You set up a portal within a domain (is part of) and make the application available. There are several ways to connect the user. Just like ThinFinity it has several version...but it's more expensive the TsPlus...but it depends what you need. See https://tsplus-remoteaccess.com/ (By the way...it's just a tip...it's not about which one is beter or not 😄 )
  5. Hi Erich In table2 you create a lookup field, let's say showColorName: Lookup definition: Key Fields : color_id Dataset : colors Lookup keys : color_id Result field : color_name For selecting the color you use a dblookupcombox so: datafield : color_id dataset : master_thing listsource: colors listfield: color_name keyfield: color_id When user selects a color from the colors table the color_id is stored in datafield and dataset For saving the name you can then use a table2.onbeforepost with something like: table2.color_name.value := table2.showColorName.value
  6. haha...of course you don't have to agree with that 😉 My largest application is about 200 forms, 20 data modules and not a single query or dataset on the form. With a dataset you have everything neatly organized and you can address any query/dataset as long as you integrate the DataModule in your form. But also smaller applications are always developed with DataModules. You have to choose the approach that suits you and your application
  7. That's right .. that doesn't work, but that has to do with the fact that loading the database and executing the code may be too fast. In addition, it is never a good idea to put Queries and Datasets on the form, that's exactly what the DataModule are for. I would choose a different setup. Try it with a DataModule then I think you don't have the problem anymore or like in my example. When using DataModules all Querie and Dataset are everywhere available. Having Query and datasets available on a form has no added value, it's the wrong approach for database development. Regards Peter
  8. mierlp

    runtime library

    Hi, You will always have to perform the installation of the runtime package once on the server...just like every other software. That's also when you have to install a certain version of .NET on a server or an update thereof, for example. This also works with an installer. Microsoft update packages can be distributed via a so-called WSUS server to servers that you manage. Maybe it is possible that the person who manages the servers and performs updates with his software he also can include the uniGUI runtime package with an update.
  9. See testcase in MainModule i put the MyConnection component and there you can use you're credentials to connect to you're mysql server mainform contains the query and dataset component form1 contains the dbgrid in the menu menu when you click the option 'Open form with dbgrid' there i open query in form1.Oncreate i set the parameters and it find record 5 testcae - dbgrid locate.zip
  10. I did a simple test within my existing application which uses forms and frames. The frame contains the dbgrid so i tested is like this in the uniFrameCreate event i put this simple code: var P : Integer; begin if not dmType.TypeCountry.Active then dmType.TypeCountry.Active; dmtype.TypeCountry.Open; P := 5; dmType.TypeCountry.Locate('typeCountryID', P, []); Result is the record pointer is to the record with ID=5, see blue line in dbgrid...WORKS Make sure that the variable you use is of type integer!
  11. The Locate method is intended to search for a record; the IndexFieldNames property is intended to sort records on the client. These operations are only performed after fetching all data matching the query. Maybe the problem is that,- at the moment you execute the code, NOT ALL RECORDS are loaded because of TMyQuery.FetchAll = false. Then only the amount of records are loaded which is se by TMyQuery.FetchRows When you you execute code by button maybe all or more records are loaded on that point. So ....set the TMyQuery.FetchAll property to True; and see if it changes the behavior. Regards
  12. MySQL with DevArt components
  13. Hi It depends on what you want to achieve. In your current setup you have no fail-over at machine level. So when VPS - Comapny2.myapp.com fails or is going down then this company can't use the application anymore. You have now made a split by assigning a vps per customer with your uniGui stack (IIS, HyperServer, UniGuiApp and Database) If you want to achieve a fail-over in the event of a machine failure, you must ensure that there is a complete copy on a fail-over vps where the correct ip address is again linked to this vps server. What you could do is run multiple application environments on 1 VPS (vps-A). You then get: - 1 IIS environment - 1 Hyper server - in this case 3 uniGui applications - 1 MySQL installation with its own database per customer A 2nd VPS (vps-B) is an exact copy of vps-A. If you change something on vps-A (eg an update of your application), you ensure that this is automatically synchronized to vps-B. Sufficient tools are available to synchronize the database. vps-B is actually a so-called standby server and is used when vps-A fails There are roughly 2 ways to monitor / realize / check if vps-A is up-and-running - DNS level failover - Server-level failover DNS level A DNS fail over can be setup using online DNS IP failovers but they cost money and many people say they are not as good as doing it on the server level, since at DNS level they check your hosting on intervenes and these can be from 4- 10 mins at any time. A Quick Google search reveals DNS Failover System Monitoring. Server level Normally you would proceed with the following: - Replicate Clone of MySQL on both Servers - Clone the file systems using clusters - Interment a IP fail over using something like UCARP A VPS is a virtual private server, so it is already virtual. There are providers that offer the option of purchasing a disaster recovery plan at VPS level, for example, where they ensure that your vps-A is automatically copied to another server and started again with the same ip address. This is what, for example, hypervisors like VMware do and is called Replication ovh.com offers very extensive possibilities when it comes to failover solutions or disaster recovery https://docs.ovh.com/gb/en/dedicated/ip-fo-move/ A other solutions can be this where you do it self: A second machine is always easy to switch everyone to vps-B during maintenance of vps-A. Then perform maintenance and switch the users back to vps-B and then you do maintenance on it. It is important to first consider what form of continuity and redundancy you want to achieve. Then you can think about the concept and realize it Greetz Peter
×
×
  • Create New...