Posts by baron42bba@emacs.ch
 (DIR) Post #AStzgk792Tv0o2n4XQ by baron42bba@emacs.ch
       2023-02-21T10:42:42Z
       
       1 likes, 1 repeats
       
       @scolobb you can even preserve that for future #emacs sessions. https://github.com/baron42bba/.emacs.d/blob/master/bba.org#save-history
       
 (DIR) Post #AVGftRIEsEiy55SzgG by baron42bba@emacs.ch
       2023-05-03T05:22:38Z
       
       0 likes, 0 repeats
       
       @galdor do you mean something like https://github.com/kiwanami/emacs-edbi or psql running in Emacs? https://emacsredux.com/blog/2013/06/13/using-emacs-as-a-database-client/ the best way is IMHO sql-interactive combined with org mode like https://howardism.org/Technical/Emacs/literate-database.html #sql #emacs
       
 (DIR) Post #AVGz00BByidJ960tdo by baron42bba@emacs.ch
       2023-05-03T06:26:48Z
       
       0 likes, 0 repeats
       
       @laejoh @galdor yes. I used it for Oracle in the past as well. Nowadays it’s mostly Vertica. http://www.bundesbrandschatzamt.de/~baron/blog/20150520-literate-oracle.html
       
 (DIR) Post #AX8lINSip25gxLhTjE by baron42bba@emacs.ch
       2023-06-28T05:29:41Z
       
       0 likes, 0 repeats
       
       @louis There are 2 reasons why I still love Perl to talk to databases: prepared statements in DBI and HERE documents. By using both of them sql looks nice. I even wrote a small eMacs functions to look around the cursor for the sql statement and open it in a sql-Mode buffer. Preparing your sql statements prevents sql injection as well. Lately I learned about prepare_cached. If your functions get called multiple times Perl is recycling the prepared statement call.
       
 (DIR) Post #AcR8sGYTlwbNBEDkWm by baron42bba@emacs.ch
       2023-11-30T07:37:22Z
       
       0 likes, 0 repeats
       
       @spudlyo @louis good formatting. But do yourself a favor and write comments about your sub-selects. If you encounter bugs in the future it makes it easier. I migrated a complex payoff program from Java into SQL a few years ago. Everything in the database. Just connecting to the DB (no stored procedures at the time) and using temporary tables. Already had lots of comments in the beginning and added more since then. Some of those queries were written over more than one day. Efficient but complex.
       
 (DIR) Post #AcR8sHjVOR12piO4Lw by baron42bba@emacs.ch
       2023-11-30T07:40:40Z
       
       0 likes, 0 repeats
       
       @spudlyo @louis of course I used Emacs sqli and Orgmode for development. Bonus points for extending babel to support my database. 😀
       
 (DIR) Post #AckAiJk9qf3IgTXyIi by baron42bba@emacs.ch
       2023-12-12T19:18:35Z
       
       0 likes, 0 repeats
       
       @steveblack @louis regarding data migration in a timely manner: it helps if you know when what is last modified. Than you can do an initial transfer and then you only transfer the changes during the switch. Had a 60 TB database migration recently.
       
 (DIR) Post #AckK08o8968hZCykXA by baron42bba@emacs.ch
       2023-12-12T21:43:24Z
       
       0 likes, 0 repeats
       
       @louis @steveblack Vertica can export to parquet and there were only a few tables involved. All tables had a last_modified column.