Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Transfer compress data
Re: Transfer compress data [message #59830 is a reply to message #59821] Sat, 29 April 2023 00:25 Go to previous messageGo to previous message
zsolt is currently offline  zsolt
Messages: 698
Registered: December 2005
Location: Budapest, Hungary
Contributor
Hello Luigi,

A had a same problem, so I created a backend part for my U++ software.
It receives JSON data as arguments in HTTP and the responses are also in JSON. This way it can be used by not only my GUI app, but a Javascript SPA (single page app) also.
HTTP is good, because I put my backent behind an Nginx reverse proxy. Nginx can compress the responses.

The other problem, you can had solved with this solution is the latency, caused by multiple SQL queries. E.g. user opens a data entry window with a lot of droplists and/or converts, based on the database, that generates a lot of SQL queries one by one, adding a very large latency. Using this JSON requests, you can send all the parameters to the server (the backend) in a JSON. It runs all the queries in place and sends back all the results in one JSON, so the latency is one request-response time only.

Jsonize framework is very useful here.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: sqlite3 encryption
Next Topic: Sqlite3 ChangePassword() failed.
Goto Forum:
  


Current Time: Wed May 15 05:55:11 CEST 2024

Total time taken to generate the page: 0.02717 seconds