TablePlus
PostgreSQL
Our great sponsors
TablePlus | PostgreSQL | |
---|---|---|
54 | 405 | |
3,186 | 14,673 | |
2.5% | 3.4% | |
0.0 | 10.0 | |
over 1 year ago | 4 days ago | |
C | ||
- | GNU General Public License v3.0 or later |
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.
TablePlus
-
Tell HN: TablePlus is a slick GUI db editor
https://tableplus.com/
It was oddly hard to find a DB editor, I needed something as slick as ArcType -- a feature packed DB editor that is recently shut down. Ideally, it would have been a vscode extension like Docker/Kubernets so I could stay in my IDE but failing to find a good looking one there, I opted to find an application.
Tried, Azure Data Studio and DBVis.com but finally happy with TablePlus. It is a freemium model but i'm okay with two windows and two tabs.
-
Under Pressure: Benchmarking Node.js on a Single-Core EC2
I'm using Table Plus to connect to the RDS Postgres database, you could use any Postgres Client.
- Modern, Native (Mac) Tool for Database Management
-
Show HN: Easily Visualize Your SQLAlchemy Data Models in a Nice SVG Diagram
This is great, especially to introduce new devs to models. I use (and love) TablePlus (https://tableplus.com/) which has a diagram generator plugin that does the same!
-
🌹 Awesome development tools for PHP 2023
Home page: https://tableplus.com/
-
From Good to Great: Scaling Applications with TypeORM Optimization
Tools like TablePlus, DBeaver, or HeidiSQL provide visual query building interfaces. While not performance analysis tools per se, they can help you build and understand complex queries more easily.
-
🐘Top Postgres GUI Clients to Master Postgres☄️🦖
TablePlus first greeted the world in 2017 and is the newest addition to the list. The UI is simple and sleek without any redundant modules, making it quick and easy to get started with.
-
Why people care about PostGIS and Postgres
TablePlus (https://tableplus.com/) is my current goto - even has a nice iOS app for on the run queries. I have fond memories of Sequel Pro and this app scratches that itch.
-
🐬Top 5 MySQL GUI Clients to Command MySQL⚡️
Starting in 2017, TablePlus is the newbie on the list, and its modern and simple UI reflects it. It supports most relational databases and some NoSQL ones. When they just started, they only supported macOS, but it is now available on Windows, Linux, and iOS (!). It is not open-source, but the roadmap is open and anyone can open an issue on their GitHub Issue Tracker. TablePlus has two plans: a free tier (has no limit on trial time) and a paid subscription model (license) with extended features.
-
Setup a Local Database
DBngin also happens to be made by the company behind my favorite database GUI tool, TablePlus. If you use TablePlus, you can click on the arrow next to the "Start/Stop" button and open the database right in TablePlus.
PostgreSQL
-
Integrate txtai with Postgres
Another key feature of txtai is being able to quickly move from prototyping to production. This article will demonstrate how txtai can integrate with Postgres, a powerful, production-ready and open source object-relational database system. After txtai persists content to Postgres, we'll show it can be directly queried with SQL from any Postgres client
-
Understanding SQL vs. NoSQL Databases: A Beginner's Guide
SQL (Structured Query Language) databases are relational databases. They organize data into tables with rows and columns, and they use SQL for querying and managing data. Examples include MySQL, PostgreSQL, and SQLite.
-
From zero to hero: using SQL databases in Node.js made easy
Node.js, MySQL and PostgreSQL servers installed on your machine
-
I Deployed My Own Cute Lil’ Private Internet (a.k.a. VPC)
Each app’s front end is built with Qwik and uses Tailwind for styling. The server-side is powered by Qwik City (Qwik’s official meta-framework) and runs on Node.js hosted on a shared Linode VPS. The apps also use PM2 for process management and Caddy as a reverse proxy and SSL provisioner. The data is stored in a PostgreSQL database that also runs on a shared Linode VPS. The apps interact with the database using Drizzle, an Object-Relational Mapper (ORM) for JavaScript. The entire infrastructure for both apps is managed with Terraform using the Terraform Linode provider, which was new to me, but made provisioning and destroying infrastructure really fast and easy (once I learned how it all worked).
-
How to dump and restore a Postgres DB with new table ownership
I've used MySQL for years. But recently, I found myself working PostgreSQL and simple things like dumping and restoring a database are different enough that I decided to document the process. It's straightforward enough once I knew how.
-
Test Driving a Rails API - Part One
A running Rails application needs a database to connect to. You may already have your database of choice installed, but if not, I recommend PostgreSQL, or Postgres for short. On a Mac, probably the easiest way to install it is with Posrgres.app. Another option, the one I prefer, is to use Homebrew. With Homebrew installed, this command will install PostgreSQL version 16 along with libpq:
-
Um júnior e um teste técnico: The battle.
PostgreSQL
-
How to choose the right type of database
PostgreSQL: Offers a robust feature set and strong compliance with SQL standards, making it suitable for a wide range of applications, from simple to complex, particularly where data integrity and extensibility are key.
-
NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB
FerretDB is an open source document database that adds MongoDB compatibility to other database backends, such as Postgres and SQLite. By using FerretDB, developers can access familiar MongoDB features and tools using the same syntax and commands for many of their use cases.
-
Preventing SQL injection attacks in Node.js
To better understand how SQL injection works, let's quickly create a vulnerable app using Node.js, Express, and a PostgreSQL database. The application takes user input from a form, constructs a SQL query, and executes it against the database to fetch some data.
What are some alternatives?
Sequel-Ace - MySQL/MariaDB database management for macOS
psycopg2 - PostgreSQL database adapter for the Python programming language
ClickBench - ClickBench: a Benchmark For Analytical Databases
ClickHouse - ClickHouse® is a free analytics DBMS for big data
sqlitestudio - A free, open source, multi-platform SQLite database manager.
phpMyAdmin - A web interface for MySQL and MariaDB
starrocks - StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. InfoWorld’s 2023 BOSSIE Award for best open source software.
Firebird - FB/Java plugin for Firebird
CodeEdit - CodeEdit App for macOS – Elevate your code editing experience. Open source, free forever.
Adminer - Database management in a single PHP file
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
SQLAlchemy - The Database Toolkit for Python