Notices tagged with postgresql

@brigrammer@poa.st

no fucking clue.

I'm using misskey, outta the box. It's got almost no English-language documentation. Takes a little bit of brainpower (and practice) just to run the bash installer.

#Misskey is a #Node #Typescript application, running on port 3000, and uses #postgresql and #redis for data backend. I'm assuming that the redis does fast cacheing of some sort, not sure what all is there. Also has #nginx set up as a #reverseproxy on port 80, even though the the documentation tells us to expose port 3000 to the world.

That's what I did. I'm assuming that most federation would still work even with port 3000 closed, but it's not worth taking the chance.

The entire application is very fast running and very snazzy looking when it's running all on one box with a good deal of hardware available.

I know that misskey works, and it's a good program, but I want it to be slightly budget-optimized and somewhat containerized so that I can tinker with other containerized applications with the #VPS I already have running.

procrastination and slow progress with #misskey #migration; I plan on migrating my #postgresql onto a #container, currently running on #baremetal #KbC #S4S #shittycode #justDeveloperThings

Hey, Fediverse! I'm looking for informed opinions on database choices.

I can stand up an Internet-facing application and have it use either mysql or postgresql. Which is the better choice, and why do you think so?

Thanks!

#Mastodev #SelfHosted #SelfHosting #Postgresql #mysql

He creado un canal en Rumble con las partes del tutorial #PostgreSQL y el lenguaje #SQL:

https://rumble.com/c/c-4781052

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

@mk @p @djsumdog I can understand you both. On one hand, software X can migrate/upgrade its file structure (e.g. "binary format") by itself by running automatically some migration/upgrade script. These scripts can be bound to version numbers (when the upgrade takes place) so the user=admin isn't bothered by it. The "in-place" migration also forces the upgrade on the user=admin.

But it seems like #PostgreSQL seem to follow an other philosophy that says that administrators are the responsible persons and it should be in their full control when the migration/upgrade should take place. So they don't want to force the upgrade on the admin's decision-making progress and let him decide whenever it takes place.

So what would be the solution? A simple script like pg_upgrade.sh that the administrator can manually run or for those people like @mk is that the installer asks "Should pg_upgrade.sh run for your automatically?" and it is done then during upgrade.

Sometimes I forget how a simple index in a column may provide a significant impact in the performance of our system ...

https://github.com/lhc/thebook/commit/8830e9f0e15943dbad4bc85d6588f67cbf3b11a0#diff-641b4ae0a3769c5f1eee1f471ee7292ed173d2f600aa9e766b1d4630227cc6baR20

Now the transactions page loads faster 🙂

#django #index #sql #postgresql

Esta es la lista con los capítulos del tutorial de #PostgreSQL y el lenguaje #SQL:

https://www.youtube.com/watch?v=8_HFyjcUt6Q&list=PLtdeXn2f7ZbNOTrW0POHNuoNbgpc-Qo-6.

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.

https://youtu.be/HKfhKnmIFLU

#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD

Looking for a good read on #postgres . Any books one can recommend for a deeper dive into #postgresql ? Something medium to advanced level but with more practical running examples than the official documentantion? ☺️

O manual do #PostgreSQL é bastante esclarecedor.

Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.

https://youtu.be/HKfhKnmIFLU

#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD

Esta es la lista con los capítulos del tutorial de #PostgreSQL y el lenguaje #SQL:

https://www.youtube.com/watch?v=8_HFyjcUt6Q&list=PLtdeXn2f7ZbNOTrW0POHNuoNbgpc-Qo-6.

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

He creado un canal en Rumble con las partes del tutorial #PostgreSQL y el lenguaje #SQL:

https://rumble.com/c/c-4781052

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.

https://youtu.be/HKfhKnmIFLU

#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD

Mon collègue DBA/sysadmin a annoncé son départ aujourd'hui...
Cela a deux conséquences :
- je vais passer une mauvaise semaine, de mauvaise humeur
- #jerecrute : un(e) libriste convaincu(e), qui aime #debian, #postgresql, #haproxy, #nginx, #python, #puppet (ou qui tolère puppet en tout cas). et qui aime/support le #télétravail #remote

Pas besoin d'être parfait ou de cocher toutes les cases... (annonce à venir, comme ça je vous laisse un peu de temps pour mettre à jour vos CV ).

voilà l'annonce pour recruter mon/ma futur(e) collègue :

https://www.entrouvert.com/actualites/2024/entrouvert-recherche-une-administratrice-bis/

Vous pouvez booster, mais encore mieux, vous pouvez répondre à l'annonce !!

Je ne l'ai pas mis dans l'annonce, mais c'est évident : il faudra me supporter, moi, mon humour et mes typos dans le code...

Bref, y a une prime pénibilité (mais elle est incluse dans le salaire affiché)
:debian: :boost_ok:
#jerecrute #télétravail #foss #job #debian #postgresql #TropDeHashtag

Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.

https://youtu.be/HKfhKnmIFLU

#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD

Better Dev Link Issue 272 - Dec 09, 2024
https://betterdev.link/issues/272

e.g. Postgres for Everything (e/postgres)
https://github.com/Olshansk/postgres_for_everything
https://www.amazingcto.com/postgres-for-everything

#dev #programming #tech #development #AI #BetterDevLink #postgres #PostgreSQL

He creado un canal en Rumble con las partes del tutorial #PostgreSQL y el lenguaje #SQL:

https://rumble.com/c/c-4781052

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

Tengo publicado en YouTube un tutorial para la instalación del servidor de base de datos #PostgresQL en una máquina virtual con #Ubuntu.

https://youtu.be/HKfhKnmIFLU

#Gratis #Free #SiguemeYTeSigo #folloback #FolloMe #Linux #SQL #BBDD