3 ms·
Not surprising. Databases have been basically awful at being approachable from the command-line. Let's say I have some HTML in some field in the db and want t
by erichanson 7y ago
Not surprising. Databases have been basically awful at being approachable from the command-line. Let's say I have some HTML in some field in the db and want to make a change to it from the terminal. How do I do this?
PostgreSQL says use an UPDATE statement, but that looks like "update template set content='<html><body>......</html>' where id = x", which means you have to paste the entire content of the page into the update statement. There's no CL-based field editor, just one of many reasons why the db feels like a black box. Awful.
Aquameta has a filesystem integration layer that lets you browse the database from the command line, grep database content, edit the content of a field using your preferred text editor.
http://blog.aquameta.com/intro-chpater2-filesystem/ http://blog.aquameta.com/intro-chpater2-filesystem/
Generally just trying to ease these pain points has been a big goal of the project... still a lot to do.
- LunaSea 7y agoThat is incorrect because PostgreSQL has XML operators.