Thanks for taking the time to respond - it sounds like an interesting research project. This indeed looks like the ideal long-term solution, where the model is hosted locally and no code is sent to the internet while it's under development. I'll take a closer look at this - thanks again.
you can run something like this on the host - make sure you use the correct container name
#!/bin/bash
# check the container name with docker ps first
container_name="instance_name_postgres_1"
echo "dumping pgsql"
# Backup command
docker exec -t "${container_name}" pg_dumpall -c -U lemmy > lemmy_dump.sql
suggest you not leave unencrypted backup on the host system but copy it somewhere else, preferably after encrypting it with gpg.
Thanks! Codewhisperer looks pretty good - especially the price - It looks similar to copilot functionally but it's free for individual use.
for anyone interested, there's a pretty decent demo here https://www.youtube.com/watch?v=CxRhACSZsJU
It also integrates with VSCode, so it looks like I can just register with AWS and replace copilot immediately. Still transmitting everything in the IDE to Amazon real time, but production systems are in EC2, so it feels slightly less intrusive than github.
thanks, yes - looks like a free entry point for autocomplete - the 'pro' tier is probably similar to copilot, by the looks of things - about the same price too.
This project seemed promising from the initial description:
https://github.com/CodedotAl/gpt-code-clippy/
but looking at the issues and history, it doesn't seem to be all that promising practically, so presumably avoiding corporate AI is not easy (yet).
from the FAQ:
How much will AI Assistant cost in JetBrains IDEs? The AI assistant is currently free to use during the preview phase. We’ll be providing the licensing and pricing model at a later date.
It looks as though it would be similar to github - they host the model and you pay a subscription for real time access while you're coding.
Still, I'd feel ideologically more at peace paying Jetbrains for IDE-as-a-service than I do slinging github a hundred smackers just to use their model from somebody else's IDE.
A public / open source solution would be ideal.
Thanks! Respectfully, I think I'm OK on that side of the equation. But you're right - you should invest in your own learning and self-directed growth - this applies to all facets of life, not just writing python modules.
I like using copilot. Now that we aren't using punch cards to write monolithic BASIC and we have an internet to work with, most of the brain work in programming is component-based integration. AI makes typing out code a LOT faster, so I won't be ditching it to resume writing out for-loops end-to-end. I just don't want every line of code available to github and definitely don't want to fund the walled AI model if I can find a way around it.
there are alive cats and dead cats at the same time.
well, that rules out your local system and ansible, at least. It seems like there's an inability for the docker containers to reach postgres definitely at the install and probably at runtime - can we check this?
first let's make sure the postgres container is on the network and has an address:
sudo docker exec -it <yourinstance>_postgres_1 /bin/sh
once you're on the container
ifconfig
which should return on the second line: inet addr:172.18.0.4 (or similar ipV4 address)
exit to return to the host and let's test connecting from the host :
nc -zv 172.18.0.4 5432 (use IP from the DB container)
Ubuntu host should respond something like : Connection to 172.18.0.4 5432 port [tcp/postgresql] succeeded!
now let's try the containers
sudo docker exec -it <yourinstance>_lemmy-ui_1 /bin/sh
now from that container test connectivity to postgres:
nc -zv 172.18.0.4 5432 (use IP from the DB container)
now the other
sudo docker exec -it <yourinstance>_lemmy_1 /bin/sh
on the docker containers the nc command should return something like
172.18.0.4 (172.18.0.4:5432) open
is that working?
This alternative installer might be a way around this issue: https://github.com/ubergeek77/Lemmy-Easy-Deploy
Hey I remember that guy! Legless Mark from myspace.
It's a good analogy - in the days before email, all you had was a username @ your BBS (Bulletin Board Server). You dialed into your local BBS's landlines with a modem - they usually had 2-4 numbers available, so that gives you an idea of scale. The BBS systems were federated so user@bbs1 could see and respond to the same threads as user@bbs2. It was nice - it worked pretty much like the fediverse actually - and the tone was similar.
The messaging systems on the BBS communities evolved into email and Usenet before big money came along and fucked everything up.
Qc2+ forks the rook on a4 and the king, so black must either move the king to the back rank where white's rook can attack it or otherwise offer the Queen ...Qb6 (which is what the computer plays). Could also play g6 but either way, by playing Qc2+ and forking the rook in check you will play Qxa4 and take the enemy rook on the next move and black is pretty much done