diff options
Diffstat (limited to '2024/talks/pgmacs.md')
| -rw-r--r-- | 2024/talks/pgmacs.md | 109 |
1 files changed, 109 insertions, 0 deletions
diff --git a/2024/talks/pgmacs.md b/2024/talks/pgmacs.md index 32c0fb13..ed9c2d20 100644 --- a/2024/talks/pgmacs.md +++ b/2024/talks/pgmacs.md @@ -43,6 +43,115 @@ working on his PhD. He continues to use Emacs Lisp in his spare time. +# Discussion + +## Questions and answers + +- Q: This is brilliant, thank you! Do you know if PGmacs works with + TRAMP? I often use TRAMP multi-hop to access databases - both + remotely when accessing via a 'bastion server' and locally when + using OCI containers + - A: There is no TRAMP support, I'm afraid. PGmacs is directly + connecting to the database server over the network. You can set + up ssh tunnels, but that would be done separately from Tramp. + Thanks :) + - \<NullNix\> you can tunnel arbitrary data over ssh + - \<NullNix\> ssh subsystems are the thing to look at, I + think\... I might look at it + - \<NullNix\> (sftp works that way: basically you can put + arbitrary progams at the remote end\... like, oh, say, + pgsql. transparently to the ssher.) + - \<jreicher\> Possibly PGmacs could setup the tunnel itself, + using TRAMP? + - With docker.el, kubel, etc, it's often possible to for example + select a container/pod/whatever that is hosted on a machine + you've connected to via TRAMP (such as + /podman:\<image\>:/path/), and trigger a terminal/eshell as well + as port-forwards and other similar things. It'd be nice to be + able to use this tool in a similar way since it would open up + the ability to use it with complex connection configurations. + Doing SSH tunnels manually is ofc totally fine in practice :) +- Q: \<Donovan\>Great work! I'm impressed. How did you come up with + this brilliant idea? + - A: First got the idea by looking at sqlite-mode +- Q: Is sqlite-mode also capable of all of this functionality (table + relations, etc)? If not, will it be possible to abstract out this + functionality from pgmacs somehow? + - A: I'm not veyr familiar with sqlite-mode but it looks more + basic. There are differences between the sql dialects so it will + be difficult to abstract it out. +- Q: Would it be possible to move it into Emacs tree? Are the + maintainers interested in it? + - A: Currently its at a very early stage and is being updated + regularly. I also have some philosophical reasons to not do it + regarding copyright transfer to the FSF. +- Q: Almost missed this one, so glad I didn't, but this may have been + answered already: what do you use for the in-buffer tables? vtable? + - A: vtable but "forked" (some changes/improvements, may + consider "merging" back with vtable core work) +- Q: + - A: + +## Notes + +- I have got 270 tables, and it stays there forever "loading" + tables, and nothing appears. +- Thanks for checking it out! You may have an authentication failure, + and PGmacs is not very good at showing that in the connect phase. + Switch to the \*Messages\* buffer and see whether there's an error + message there. + - This is happening with me as well. I noticed this error message + in Postgres Logs. It works if I open the postgres database. + - db-1 \| 2024-12-08 18:58:41.524 UTC \[48\] STATEMENT: + CREATE EXTENSION IF NOT EXISTS vector + - db-1 \| 2024-12-08 18:59:13.831 UTC \[50\] ERROR: could + not open extension control file + "/usr/share/postgresql/14/extension/vector.control": No + such file or directory + - In \*Messages\* buffer, this is what I see + - pg-bind: Wrong type argument: stringp, 97 +- OK, thanks for this feedback. It looks like your Postgres vector + extension is not well set up, but that really shouldn't be causing + a complete connection failure. You can comment out the line + (pg-vector-setup con) in function pgmacs-open in pgmacs.el and see + whether that helps + - - Let me try that and report back. + - I got this error: pg-do-startup: Process postgres not + running: failed with code 111 + - OK, that means that the network connection failed. There is + probably more error information in the backtrace + - Ah sorry, had stopped the pg. This time I got the same error + - pg-bind: Wrong type argument: stringp, 97 + - But it didn't try to load vector extensions (from pg logs). + - With toggle-debug-on-error, this is the backtrace + - [https://gist.github.com/ankitrgadiya/d9ae038489e4f680e3037e2e61584312](https://gist.github.com/ankitrgadiya/d9ae038489e4f680e3037e2e61584312){rel="noreferrer noopener"} + - OK, thanks for that backtrace. I don't immediately see what + is wrong here. There is something strange about that + shared_urls table, it seems. Are you using pg-el from the + github repo? + - I created the github issue to continue the discussion: + [https://github.com/emarsden/pgmacs/issues/9](https://github.com/emarsden/pgmacs/issues/9){rel="noreferrer noopener"} +- - - BTW I'm using the postgres docker image. + +- This is amazing! Image inline :o !! + +- I'm impressed by the inline images. Just sprinkle a little elisp + and voila. + +- A PostGIS point field -\> osm.el integration would be very cool +- Interesting idea, will look into that. +- \<sctb\> emarsden: Super slick Emacs/PG hacking and presentation! + Eat your heart out, MS Access +- \<NullNix\> another package I never knew I needed +- \<alzai\> Very cool, I'm currently using PG on a small project and + it's always a pain to leave emacs to do checks in the database. +- \<NullNix\> I just wish it had existed when I was doing massive db + work in the 90s/2000s +- \<gs-101\> Just installed it, to prevent me from forgetting about + it. + +\ + [[!inline pages="internal(2024/info/pgmacs-after)" raw="yes"]] |