run postgresql with systemctl
sudo pacman -S postgresql
find version & build from source
| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
| <?php | |
| /** | |
| * 1. You have to store your client SSL certificates on your Laravel server, in my case this is /var/certs/mydomain.com/... | |
| * 2. You have to right select SSL mode for PostgreSQL (see https://www.postgresql.org/docs/current/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS), verify-full means your server CA is signed for real domain name for the PostgreSQL server (recommended) | |
| * 3. Go to Laravel config/database.php to the section 'pgsql' and extend it to the following: | |
| */ | |
| return [ | |
| /*...*/ | |
| 'connections' => [ | |
| /*'mysql' etc*/ |
| addTask({ | |
| variables: { input }, | |
| optimisticResponse: { | |
| addTask: { | |
| __typename: 'Task', | |
| id, | |
| ...input | |
| } | |
| }, | |
| update: (proxy: any, { data: { addTask } }: any) => { |
| <x-app-layout> | |
| <div class="py-16 bg-gray-50 overflow-hidden lg:py-24"> | |
| <div class=" max-w-xl mx-auto px-4 sm:px-6 lg:px-8 lg:max-w-7xl"> | |
| <div class="relative"> | |
| <h2 class="text-center text-4xl leading-8 font-extrabold tracking-tight text-indigo-600 sm:text-6xl">Encuentra un trabajo en Tech de forma remota</h2> | |
| <p class="mt-4 max-w-3xl mx-auto text-center text-xl text-gray-500">Encuentra el trabajo de tus sueños en una empresa internacional; tenemos vacantes para front end developer, backend, devops, mobile y mucho más!</p> | |
| </div> | |
| </div> | |
| </div> | |
| </x-app-layout> |
| <div class="bg-gray-100 py-10"> | |
| <h2 class="text-2xl md:text-4xl text-gray-600 text-center font-extrabold my-5">Buscar y Filtrar Vacantes</h2> | |
| <div class="max-w-7xl mx-auto"> | |
| <form> | |
| <div class="md:grid md:grid-cols-3 gap-5"> | |
| <div class="mb-5"> | |
| <label | |
| class="block mb-1 text-sm text-gray-700 uppercase font-bold " | |
| for="termino">Término de Búsqueda |