Jailer
babelfish_extensions
Jailer | babelfish_extensions | |
---|---|---|
218 | 7 | |
2,707 | 262 | |
- | 1.9% | |
9.6 | 9.7 | |
4 days ago | 2 days ago | |
Java | TSQL | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Jailer
- Jailer – open-source database client
- Show HN: Jailer is a unique open-source database client tool
-
DBeaver – open-source Database client
Some other tools I have also enjoyed:
DBVisualizer: https://www.dbvis.com/ (for exploring the schema)
Jailer: https://wisser.github.io/Jailer/ (for data browsing)
Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.
Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.
- Database browsing tool with sophisticated and animated Java Swing UI
- Jailer is a unique open-source database client tool
-
Why people care about PostGIS and Postgres
I also found DBeaver to be a huge improvement over tools I used earlier.
Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer
- Jailer, a unique open-source database tool
- Jailer is a unique open-source database tool
- FLaNK Stack Weekly for 14 Aug 2023
- UniversalProblemSolver
babelfish_extensions
- Ask HN: What rabbit hole(s) did you dive into recently?
-
Transpile Any SQL to PostgreSQL Dialect
[2] https://github.com/babelfish-for-postgresql/babelfish_extens...
-
DBeaver – open-source Database client
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/
-
'We had to educate Oracle about our contract,' CIO says after Big Red audit
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....
-
The problem with SQL servers licensing costs
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/
-
A Technical Dive into PostgreSQL's replication mechanisms
> 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.
- Babelfish for PostgreSQL
What are some alternatives?
dbgate - Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
realtime - Broadcast, Presence, and Postgres Changes via WebSockets
Replibyte - Seed your development database with real data ⚡️
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Ebean ORM - Ebean ORM
H2 - H2 is an embeddable RDBMS written in Java.
presto - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io) [Moved to: https://github.com/trinodb/trino]
jExifToolGUI - jExifToolGUI is a multi-platform java/Swing graphical frontend for the excellent command-line ExifTool application by Phil Harvey
SDEBM - Structured Data Exploration BenchMark
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
jOOQ - jOOQ is the best way to write SQL in Java
RDS-sanitized-snapshots - Take periodic snapshots of RDS databases, sanitize them, and share with other accounts. Useful for QA/dev databases.