Thanks for overview. I really like export options, that's a killer feature. Is there a way to use dbee with current working directory? I prefer to store my sql snippets in a project folder rather than having a system-wide notes storage.
You can maybe try setting the `config.editor.directory` parameter to cwd - search the docs how to get cwd from lua (I think it's something like `vim.fn.getcwd()`.
Hey nice plugin. In the example you showed, it uses docker to enter the database username and password. How do i enter username and password for a remote database not based on Docker?
This should give you a pretty good understanding of how postgres urls are structured - www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING
if anyone else needs this, heres my keymap: vim.keymap.set("v", "r", '"vy:lua require("dbee").execute(vim.fn.getreg("v"))', { desc = "Run SQL" }) this will copy the selected text into register v and use dbee api to execute the query.
rad. if we're connecting to an existing application db with a large model, does this already handle introspection in any way or would it be preferable for the user to perform introspection manually via other tools. ie dumping sql object definitions to disk via sqlpackage.exe in mssql. and navigating them using file search tools which are already about as robust as possible in nvim
Well, I'll say this: I made dbee to be just a dumb "select text and that on the database" and then just retrieve results in neovim. Since then, I did a refactor of the entire codebase, so that the backend could be used as a library with any frontend (but the only frontend that currently exists is that for neovim). And that backend is pretty powerful in terms of gathering large results. To answer your question: You should be able to retrieve pretty big results from dbee and then use the api to store the result to a csv or json file. But if you want to create a backup, which you want to be able to restore later, go with other tools (e.g. sqlpackage.exe or psql).
Hi!I Download the plugin and it runs nicely, however when a create a connection a can't enter the connection created, i can delete or edit, but i cannot enter, do you have any tips about it?
Very nice plugin. It's great to have a lua+go alternative to the already great vim-dadbod.
thank you. very helpful. a video on configuring the plugin from a to z and with connecting to a database, would be nice
Thanks, this is exactly what I was searching for!
This is a game changer, at least for me!!!Great work!!!
This is great, thank you for this tool and the video. It's really neat!
you're doing awesome work. I'm excited to try it.
simple and to the point, thank you :)
Great plugin. Thank you o/
Thanks for overview. I really like export options, that's a killer feature.
Is there a way to use dbee with current working directory?
I prefer to store my sql snippets in a project folder rather than having a system-wide notes storage.
You can maybe try setting the `config.editor.directory` parameter to cwd - search the docs how to get cwd from lua (I think it's something like `vim.fn.getcwd()`.
Hey nice plugin.
In the example you showed, it uses docker to enter the database username and password. How do i enter username and password for a remote database not based on Docker?
Amazing work
Sir may i ask, how can nvim dbee connect to a docker postgres database. How should define the url.
This should give you a pretty good understanding of how postgres urls are structured - www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING
Im probably being dumb, but what button do you press to execute the query? learning nvim and i just can't get the query to execute
How do i run the query? do i need to create a keymap or am i missing something?
nvm i got my keymap setup!
if anyone else needs this, heres my keymap:
vim.keymap.set("v", "r", '"vy:lua require("dbee").execute(vim.fn.getreg("v"))', { desc = "Run SQL" })
this will copy the selected text into register v and use dbee api to execute the query.
rad. if we're connecting to an existing application db with a large model, does this already handle introspection in any way or would it be preferable for the user to perform introspection manually via other tools. ie dumping sql object definitions to disk via sqlpackage.exe in mssql. and navigating them using file search tools which are already about as robust as possible in nvim
Well, I'll say this:
I made dbee to be just a dumb "select text and that on the database" and then just retrieve results in neovim.
Since then, I did a refactor of the entire codebase, so that the backend could be used as a library with any frontend (but the only frontend that currently exists is that for neovim). And that backend is pretty powerful in terms of gathering large results.
To answer your question:
You should be able to retrieve pretty big results from dbee and then use the api to store the result to a csv or json file. But if you want to create a backup, which you want to be able to restore later, go with other tools (e.g. sqlpackage.exe or psql).
Hi!I Download the plugin and it runs nicely, however when a create a connection a can't enter the connection created, i can delete or edit, but i cannot enter, do you have any tips about it?
Hard to tell - I recommend you open an issue on github - maybe someone will be able to help you :D
What font are you using?
Comic code (tosche.net/fonts/comic-code) - here is the video that sold me on it :) - th-cam.com/video/1zvWXT53puQ/w-d-xo.html
@@cheesed_up Thanks!
@@cheesed_up Are you using lualine? How do you get the distinct bubbles like that it looks great!
@@Cameronbailey17 looks like a minimal lualine on top of tmux
very nice, neovim is definitely better