babelfish_extensions VS computer

[2] https://github.com/babelfish-for-postgresql/babelfish_extens...

DBeaver works surprisingly nicely with less popular DBs. I work with Babelfish for PostgreSQL [1], it supports connections with SQL Server client libs. Most GUI client tools (like SSMS) expect "real" SQL Server on the other end of the wire - depend on various system views for DB introspection, so only partially work with Babelfish. Even if client tool is based on JDBC (like SQuirell SQL), it doesn't guarantee that this tool won't use additional SQL Server-specific querues for i trospection. DBeaver is much better at this, I guess it is using JDBC API or DB-neutral INFORMATION_SCHEMA views.

[1] https://babelfishpg.org/

Was just about to write that AWS does that, but no, it's only for MS SQL Server: https://babelfishpg.org/, https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide....

Migration to Postgres from MS SQL Server doesn't have to be a complete app rewrite. Obviously any .Net components would be a problem, but if it's just a matter of existing clients and T-SQL, there's always Babelfish.

https://babelfishpg.org/

> moving some data from SQL Server to Postgres

I don't have any first-hand experience with Postgres replication to share, just, when moving DB from MSSQL, Babelfish extensions for Postgres (https://babelfishpg.org/) may be of interest.

gs (ghostscript), mutool, ocrmypdf...

To add/remove: mutool merge -h

To split PDF pages: mutool poster -h

I made a script here that I use frequently for scanned documents: https://github.com/chapmanjacobd/computer/blob/main/bin/pdf_...

Shrink PDFs: gs -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dPDFSETTINGS=/prepress -dNOPAUSE -dQUIET -dBATCH -sOutputFile=out.pdf in.pdf

(or switch prepress to ebook to shrink more)

or to really shrink, b&w only:

gs -q -dNOPAUSE -dBATCH -dSAFER -sProcessColorModel=DeviceGray -sColorConversionStrategy=Gray -dDownsampleColorImages=true -dOverrideICC -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dPDFSETTINGS=/screen -dColorImageDownsampleType=/Bicubic -dColorImageResolution=120 -dGrayImageDownsampleType=/Bicubic -dGrayImageResolution=120 -dMonoImageDownsampleType=/Bicubic -dMonoImageResolution=120 -sOutputFile=out.pdf in.pdf

I've been putting my whole home folder under git for almost a year [1].

I haven't seen any other repos on GitHub with a similar layout. Why do people rely on GNU Stow and other complicated tools to essentially do what git does? I haven't noticed any performance problems with just using git.

[1]. https://github.com/chapmanjacobd/computer/

with these settings: https://github.com/chapmanjacobd/computer/blob/main/.github/firefox/ublacklist-settings.json

The problem with a lot of these tools is there is no incremental escape hatch. I had 25,000 tabs last year which I saved as a line delimited text file.

Then every day I automate opening 7 tabs and I force myself to get through them. Sometimes it takes 2 minutes, sometimes it takes an hour. Sometimes it ends with me adding 50 more links to the text file. Sometimes the tabs are garbage but often they are worthwhile.

https://github.com/chapmanjacobd/computer/blob/main/.config/...

https://github.com/chapmanjacobd/computer/blob/main/.config/...

But over the past year I've gone through 2,555 tabs! So it seems like it is working. Maybe in 10 years I'll reach tab zero

autocrop.lua

I started doing this with my phone and it made formatting my phone painless. The hardest part is getting started. I still haven't added all my config files to git; I have a daily script that will remove one line from my home directory gitignore so I can incrementally add config files. And it has already brought me a lot of peace of mind even if I'm only like 30% of the way done on the desktop.