Jump to content

Skepsis IT

uniGUI Subscriber
  • Posts

    222
  • Joined

  • Last visited

  • Days Won

    6

Posts posted by Skepsis IT

  1. Oscar Flor thanks for the answer. This is exactly the dilemma multiple firebird dbs or one big sql server. Furthermore after piotre post a thought of postgres wake up because of the free situation. But this means that you must rent 2 vps one for the db (linux because as I read performance on windows it very bad) and one windows vps for unigui server.

  2. I believe that at this forum, a lot of people including me had little or not at all experience in web development because we came from delphi world. And now, thanks to Farshad and his team, we create sophisticated web applications. The result came from a lot of experiment with unigui product and of course read almost all posts of the forum, yes "all". As you know my friend "No pain, no gain" :D

     

    Regards

    • Upvote 1
  3. I'll try to describe it as simple as I can.

     

    When a user loads unigui app on his browser a session is started for this user, let's say as a channel of conmunication. Everything that is placed on your server module let's say a constant is common for all sessions for all users, on the other hand the properties thar are placed on mainmodule are "alive" only for the current session. When a session is restarted mainmodule reinitialized.

     

    That's for a start. You must experiment a little bit for better understanding.

     

    I hope this was helpful a little bit for you

  4. Hi Zizzig and Andy.

     

    Of course there is no correct answer because both have advantages and disadvantages. The question basically is for sharing experiences from other developers like Andy did.

     

    I conclude that all developers that have personal experience used multiple databases and this has it's meaning.

     

    Thanks again for all the replies

  5. Piotr thanks for the reply.

     

    Of course one db is the easy way and the most straight forward. You mentioned already some of the advantages.

     

    The only fear that I have is that if the database get corrupted nobody can access it and work. The loss of data perhaps is for everyone.

     

    I have seen occasions ant troubleshoot corrupted databases and it is a nightmare.

     

    Do you have a personal experience with a system that uses one database for hundreds of companies?

  6. Wilton_rad thanks for your answer, and for sharing your experience.

    I tend to go for multiple databases.

     

    Could you share the technical view of having multiple databases and unigui. What I meant is that you have one dll and one db for each customer, or one dll and multiple dbs?

     

    Thanks again

  7. Hi and thanks for your answer,

     

    How many users are you expecting to have?
    Which database are you planning to use?

     

    The problem is that we don't know exactly, we hope a lot :) , if I go for one database I will choose SQL Server, but If the solution is for multiples I have a thought of firebird.

     

     

    The smaller the database , the faster it responds.

    I would go for multiple databases.

    There is also the issue of not "mixing" the clients data in case of a single database.

     

    I agree with you adragan for faster response. With multiple databases it is also easy to scale out, with one db only scale up is an option. The disadvantage is that processes such backup or upgrade or more time consuming and perhaps they hide problems... Furthermore multiple database take more space on hard disk (of course the costs nowadays are low for disk space).

     

  8. Hi everybody,

     

    I post the following topic because I implement a "framework" that our applications will use an application server containing all objects and business logic that serves rest/json data and use unigui as frontend without much business logic at it (I try to have none). The question is that if it's better to have a model that uses one db per customer, or one db for all customers (just have a foreign key to a table containg customers). I've read a lot of advantages and disadvantages on books and web, but I'll like to here the opinions of all unigiuers because I respect all of them a lot. Moreover if someone has a real case study and wants to share it, that will be great.

     

    Moreover another topic is how easy and if is achievable to have multiple dll's running on different subdomains on IIS or Apache? Just for scalability and performance issues.

     

    Regards,

    Skepsis IT

  9. Hi to all,

     

    I have a thought to implement a Pos system with unigui. One of the problems that i face is the timeout of session. In a pos a user will login and must not have a timeout till the log off time. The pos may stay idle for a long period.

     

    Is there a way to postpone session timeout?

     

    Thanks to all

  10. Hi,

     

    I am working on a function that returns a uniframe that contains a unipanel with some components in it. When I execute the function I got an access violation and after that the following error:

     

    mainpanel:TUniPanel:Config Option: O63->bodyBorder:false<br/>is refering a previous request,<br/>it's not allowed in AJAX request or JS handler.<br/>Use equivalent Public Property or Method instead.

     

    Can anybody interpret the above message?

     

    Regards.

  11. Hi,

     

    my thought about this is that you must implement a mechanism that saves the view of a unidbgrid perhaps on a file or a database table and restore it when it is needed. If you want to go further a per user view table will be great.

     

    Regards

×
×
  • Create New...