pcsoft.us.windevCopyright 2026, PC SOFT21 Apr 2015 22:21:00 Z18 Apr 2015 12:49:00 ZHi, I am new in webdev and windev tools. But I am not new in RDBMS and application development. The only problem is that about 25 years has passed since my last 4GL programming. At the moment I am reading the WB tutorial and performing the exercises. I would like to develop an 100% web based application that will run as SaaS. Registration of a new Company I plan to make full under application control, without any help from me or my developers. I would kindly aks for advice how to construct my database, file naming, indexing...etc for SaaS so that data among the companies are not mixed togehter. When my application will be available for the market I expect to have about 800-1000 Companies using the application as SaaS. I believe that nobody would advice to put the phisical database for each SaaS user (a Company) in a separate sub-folder at the server machine. That would be impossible for the maintenance. So, the only solution might be that all data for all SaaS users (about 800-1000 Companies) are located in one phisical database, but strictly separated from each other. How to do this ??? In order to avoid data mixing among Companies I believe that especial kind of indexing should be applied. Could you, please give me some advise. In my application I will have about 60-70 files in the database. Thanks30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51715/read.awp21 Apr 2015 22:21:00 ZHello Raul2 The multi-tennanted server is just a standard MS Windows server 2008 running on a VM at a data centre. We setup a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51715/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51715/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51708/read.awp21 Apr 2015 16:55:00 ZQuote Allard Hello Zdenko You could also use windev on the user machine and the db in the cloud. Then you donnot need…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51708/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51708/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51707/read.awp21 Apr 2015 16:50:00 ZQuote Al Hello Zdenko Our SaaS is a multi-tenanted server running MS Windows Server 2008 R2 so of course each client …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51707/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51707/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51643/read.awp20 Apr 2015 08:19:00 ZHi Allard, Yes, I think that might be the best option for my development. As Fabrice said, at the moment the user connects to…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51643/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51643/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51624/read.awp19 Apr 2015 16:53:00 ZHello Zdenko You could also use windev on the user machine and the db in the cloud. Then you donnot need the expensive citrix…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51624/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51624/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51621/read.awp19 Apr 2015 00:34:00 ZHello Zdenko Our SaaS is a multi-tenanted server running MS Windows Server 2008 R2 so of course each client is completely ind…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51621/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51621/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51617/read.awp18 Apr 2015 20:28:00 ZHi Zdenko if you use windev, then the simplest way is for each user or group of users to have his own DB and use a replicatio…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51617/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51617/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51616/read.awp18 Apr 2015 20:22:00 ZHi Viggo, considering that I would use HFSQL, I would just need to add a hModifyStructure in the init code of my project... E…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51616/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51616/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51614/read.awp18 Apr 2015 18:28:00 ZHi, In addition to my previous post, another option should be taken into account. What if I decide NOT to develop the applicati…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51614/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51614/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51613/read.awp18 Apr 2015 17:59:00 ZThank you very much for you answer Fabrice. But Viggo stated the right question. I would be delightfull to have 1000 users, but …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51613/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51613/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51612/read.awp18 Apr 2015 17:14:00 ZHi Fabrice Impressive !! One question I think need attension: What if you, some day in the future, wants to change one of …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51612/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51612/read.awpDatabase design for SaaSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51610/read.awp18 Apr 2015 16:35:00 ZHi Zdenko, I see two solutions for your problem. 1. All records are in one DB, and one field contains the company ID/GUID …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51610/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51604-database-design-for-saas-51610/read.awpDatabase design for SaaS