Re: Recommended web and database server specification

2019-08-15 Thread Nick Holland
On 8/14/19 9:20 PM, Aaron Mason wrote: > Hi Tito > > Can you tell us more about the database? How often will its data be > changed, added to, etc? How much data do you have? How complex are > your DB queries? These answers will help determine the RAM and > processor requirements for the databas

Re: Recommended web and database server specification

2019-08-15 Thread Nick Holland
On 8/14/19 9:20 PM, Aaron Mason wrote: > Hi Tito > > Can you tell us more about the database? How often will its data be > changed, added to, etc? How much data do you have? How complex are > your DB queries? These answers will help determine the RAM and > processor requirements for the databas

Re: Recommended web and database server specification

2019-08-15 Thread Roderick
On Thu, 15 Aug 2019, Roderick wrote: It [sqlite] is good integrated with tcl, hence I would use as server: https://de.wikipedia.org/wiki/NaviServer I mean, I would not use php. :)

Re: Recommended web and database server specification

2019-08-15 Thread Roderick
On Thu, 15 Aug 2019, Tito Mari Francis Escano wrote: to prepare this be deployed and run for quite a long time and ready for about 60,000 visits per day at most. Perhaps sqlite: https://www.sqlite.org/whentouse.html It is good integrated with tcl, hence I would use as server: https://de.

Re: Recommended web and database server specification

2019-08-14 Thread Jordan Geoghegan
On 8/14/19 9:40 PM, Tito Mari Francis Escano wrote: Hi Jordan, Thanks for replying. I apologize I forgot to mention that I was asking for the web and database spec because this will be an on-premise deployment, cloud platforms are out of the equation. I hope this will clarify my concern ask

Re: Recommended web and database server specification

2019-08-14 Thread Tito Mari Francis Escano
Hi Jordan, Thanks for replying. I apologize I forgot to mention that I was asking for the web and database spec because this will be an on-premise deployment, cloud platforms are out of the equation. I hope this will clarify my concern asking for server specification for a web and database se

Re: Recommended web and database server specification

2019-08-14 Thread Jordan Geoghegan
On 8/14/19 7:56 PM, Tito Mari Francis Escano wrote: Hi to everyone at misc, I'm recently working on an OpenBSD-based PHP7 web application with PostgreSQL-backend for a local government agency and was wondering what would you recommend as the acceptable server specification. This web applica

Re: Recommended web and database server specification

2019-08-14 Thread Tito Mari Francis Escano
Hello Aaron, Thanks for responding. The code for the PHP7 web app along with the complexity of the database queries like a four table join can be seen here: https://github.com/titomarifrancis/dap-dbms. I hope you forgive the simplicity of my code, I tried to use a framework but given the time

Re: Recommended web and database server specification

2019-08-14 Thread Aaron Mason
Hi Tito Can you tell us more about the database? How often will its data be changed, added to, etc? How much data do you have? How complex are your DB queries? These answers will help determine the RAM and processor requirements for the database. As for the web server daemon itself, I think Re

Recommended web and database server specification

2019-08-14 Thread Tito Mari Francis Escano
Hi to everyone at misc, I'm recently working on an OpenBSD-based PHP7 web application with PostgreSQL-backend for a local government agency and was wondering what would you recommend as the acceptable server specification. This web application won't reach the Google or Facebook level of visits