PostgreSQL and Memcached in LAMP
-
I have a client that built a custom web app, I think it won't be a problem to run it on the LAMP container but the client is asking for PostgreSQL & Memcached, both don't seem to be enabled on the current LAMP.
This is the client requirement :
Apache2.4. proxied by Nginx 1.14+ (ssl, static resources);
Nginx shall be compiled with X-Accel, http2, ssl at a minimum
Database server: PostgresSQL 11 with contrib packages
PHP 7.3+ (fpm or fastcgi if multiple sites are hosted on the same server, dso (mod-php) otherwise )
Serverside extra-security will be a plus (eg: Suhosin for PHP, apache security modules)I think the current LAMP container already provide all of this but I need to know if it's possible to also provide PostgreSQl and Memcached, any help is much appreciated.
-
-
here is another piece : https://git.cloudron.io/cloudron/php7.3-postgres-app/
Combined with this tutorial https://cloudron.io/documentation/guides/multiple-databases-lamp/ there is everything to install this custom app to one's cloudron
-
@rmdes If you don't want to get into docker packaging stuff, it's easiest to use redis instead. Is that an option? Usually php frameworks like lavarel allow you to switch between these easily.
-
@rmdes If you don't want to get into docker packaging stuff, it's easiest to use redis instead. Is that an option? Usually php frameworks like lavarel allow you to switch between these easily.
@girish by the way, is there some kind of phpmyadmin built in this image to handle PostgreSQL from a web interface ?
the agency my non profit client hired is asking me for this :
How can the PostgreSQL database can be managed? eg phpPgAdmin would be a web based sollution (phpPgAdmin needs to be added to the container as well) or via a SSH tunnel (can I connect to the container using SSH?) ? Then please confirm that PostgreSQL extensions: btree_gist, hstore, pg_trgm, plpgsql, unaccent can be installed. ----Regarding memcache :
Regardind memcached server and the php-memcached extension, the installation can be done in one RUN line inside the container dockerfile.
-
@girish by the way, is there some kind of phpmyadmin built in this image to handle PostgreSQL from a web interface ?
the agency my non profit client hired is asking me for this :
How can the PostgreSQL database can be managed? eg phpPgAdmin would be a web based sollution (phpPgAdmin needs to be added to the container as well) or via a SSH tunnel (can I connect to the container using SSH?) ? Then please confirm that PostgreSQL extensions: btree_gist, hstore, pg_trgm, plpgsql, unaccent can be installed. ----Regarding memcache :
Regardind memcached server and the php-memcached extension, the installation can be done in one RUN line inside the container dockerfile.
@rmdes I suggested adminer.org here as an omnipurpose interface that works with more DB types:
-
Would be great to add this http://phppgadmin.sourceforge.net/doku.php?id=about to the current LAMP PostgreSQL app, so that it's easier to manage databases inside this app.
