staticlibs (u/staticlibs)

staticlibs commented on FLTK 1.4 Released fltk.org/articles.php?L19... · Posted by u/mappu

staticlibs · 9 months ago

Fltkhs [1] was the best ever experience I've had while doing small/auxiliary GUI utilities. Now using NWG [2] for that (UI forms examples [3]) and it is so much less elegant and so much more verbose than Fltkhs. Resulting lean EXEs without any bundled runtime are nice though.

[1] https://github.com/deech/fltkhs

[2] https://github.com/gabdube/native-windows-gui

[3] https://github.com/wiltondb/wiltondb/wiki/WiltonDB-Data-Tran...

staticlibs commented on Ask HN: What rabbit hole(s) did you dive into recently? · Posted by u/RetroTechie

staticlibs · a year ago

Chasing memory leaks in BCP [1] data load implementation in Babelfish [2]. Spotted unusually high RAM usage, decided to look deeper and got into a rabbit hole. Haven't had this fun of overnight debugging (of Postgres guts) for a long time. As a result found 4 different leaks and one (unlikely to be triggered) crash. And now have BCP data load impl with 100% constant-bounded RAM usage in a DB server process.

[1] https://learn.microsoft.com/en-us/sql/tools/bcp-utility?view... [2] https://babelfishpg.org/

staticlibs commented on Transpile Any SQL to PostgreSQL Dialect gitlab.com/dalibo/transql... · Posted by u/fljdin

ThinkBeat · a year ago

I see that the support for Oracle is mentioned and clearly present in the source code, is that also at present the only supported database? Any hope for transactSql (Microsoft Sql. Server)

staticlibs · a year ago

Transact-SQL support (both queries and stored procedures) for PostgreSQL is implemented in Babelfish extensions [1]. It is implemented from the ground up as a "pl/tsql" language for Postgres [2], without using SQL-to-SQL transpilation like JOOQ.

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

staticlibs commented on Pg_hint_plan: Force PostgreSQL to execute query plans the way you want github.com/ossc-db/pg_hin... · Posted by u/justinclift

staticlibs · a year ago

What is cool about Postgres extensions ecosystem, is that new functionality can be built upon existing extensions. For example, Babelfish (SQL Server compatibility layer for Postgres) uses pg_hint_plan to implement Transact-SQL hints support [1]. This is really useful, because existing queries, that were optimized for MSSQL, may require tuning when moved to Postgres/Babelfish, and it is great to have additional knobs for tuning.

[1] https://github.com/babelfish-for-postgresql/babelfish-for-po...

staticlibs commented on DBeaver – open-source database client github.com/dbeaver/dbeave... · Posted by u/saikatsg

elric · a year ago

Jet Brains care? Do they? In my experience their tools are some of the ugliest out there. Granted, that's highly subjective, but there is "something" off about IntelliJ that I can't really put my finger on. Maybe the lack of whitespace. Maybe the weird tabs.

staticlibs · a year ago

I meant that Jet Brains do care about GUI support in OpenJDK (mainstream Java), their flagship products depend on this, they employ a number of ex-Oracle GUI devs and contribute fixes upstream. Just there are no new major projects in GUI area in OpenJDK for years, because none of big contributors is interested in it. Compare this to improvements in non-GUI areas like Java 21 Threading and also the whole Graal thing.

staticlibs commented on DBeaver – open-source database client github.com/dbeaver/dbeave... · Posted by u/saikatsg

pachico · a year ago

Ugliness is something I found to be quite common in Java based apps. I never understood why, though.

staticlibs · a year ago

None of major Java/OpenJDK contributors (Oracle, Red Hat, SAP etc) care about desktop GUI Java libs. Jet Brains do care, but they are not major. All Java progress is concentrated on backend cloud services for 10-15 years already. This can explain why Swing is so underdeveloped and JavaFX was thrown away. Basically much more effort is required to make Java GUI look and behave nicely, comparing to Delphi/Lazarus or .NET GUI libs or Qt.

staticlibs commented on DBeaver – open-source database client github.com/dbeaver/dbeave... · Posted by u/saikatsg

dfee · a year ago

I don’t know why it matters to me, but I’ve always been put off by it being ugly and using non-native widgets. That may be the only reason I’ve paid for TablePlus.

I’d probably be fine with a great TUI interface, too. So it’s really this intermediate UI that irritates me.

staticlibs · a year ago

DBeaver uses SWT toolkit, its widgets are as platform-native as Java can do. Some of them can be much faster with long text editing than default Java Swing widgets.

staticlibs commented on DBeaver – open-source database client github.com/dbeaver/dbeave... · Posted by u/saikatsg

staticlibs · a year ago

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 queries for introspection. DBeaver is much better at this, I guess it is using JDBC API or DB-neutral INFORMATION_SCHEMA views for introspection.

[1] https://babelfishpg.org/

staticlibs commented on Comparing Postgres Managed Services: AWS, Azure, GCP and Supabase blog.peerdb.io/comparing-... · Posted by u/saisrirampur

staticlibs · a year ago

Feature set of Postgres on AWS in the article omits Babelfish feature. It is definitely worth mentioning, at least for some unfortunate people who are stuck with SQL Server, but would like to use Postgres as all others do. When you can use BCP or OPENQUERY to move your data to Postgres, instead of COPY - this can make a big difference for some of us.

staticlibs commented on Supermium – Chromium fork for Win 2003/XP and newer win32subsystem.live/super... · Posted by u/Tiberium

ck2 · 2 years ago

Windows 7 is still stuck on Chrome 109

There are 3rd party patches to install 120+ but needs safety audit (and unfortunate name)

https://github.com/Blaukovitch/GOOGLE_CHROME_Windows_7_CRACK

Considering there are critical vulnerabilities in 109 you'd think Google might consider the non-evil thing to release an ESR

staticlibs · 2 years ago

> WARNING: Files not signed! I don't have a Google Inc. private key at the moment.

Its readme is worth reading.

u/staticlibs

KarmaCake day71April 12, 2017

About

alex@wiltondb.com https://wiltondb.com

View Original