vscode-postgres VS pglast

Compare vscode-postgres vs pglast and see what are their differences.

vscode-postgres

PostgreSQL extension for vscode providing explorer, highlighting, diagnostics, and intellisense (by Borvik)

pglast

PostgreSQL Languages AST and statements prettifier: master branch covers PG10, v2 branch covers PG12, v3 covers PG13, v4 covers PG14, v5 covers PG15, v6 covers PG16 (by lelit)
SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
surveyjs.io
featured
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
vscode-postgres pglast
2 2
210 337
- -
3.8 8.9
2 months ago 22 days ago
TypeScript Python
MIT License -
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

vscode-postgres

Posts with mentions or reviews of vscode-postgres. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-06.

pglast

Posts with mentions or reviews of pglast. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-06.
  • Show HN: Postgres Language Server
    21 projects | news.ycombinator.com | 6 Aug 2023
    Can't you just give some love to the issue https://github.com/pganalyze/libpg_query/issues/44 instead ? As I said before this would be very helpful for the community because there are a lot of libraries that use libpg_query and cannot be used on windows (f.e see https://github.com/lelit/pglast/issues/7).

    It seems that the only problem for fixing the problem is:

    > Thanks for the offer, but the problem is our team being time limited / having an engineer with a Windows machine ready to take this on, not that we wouldn't want to pay someone to work on it :)

    (https://github.com/pganalyze/libpg_query/issues/44#issuecomm...)

    Hosting the LSP elsewhere is really needed since if people wanted to go that way they could use Remote ssh (https://code.visualstudio.com/docs/remote/ssh) to host the whole dev environment on linux and connect to it.

    Thank you

  • Open Source SQL Parsers
    17 projects | dev.to | 8 Oct 2021
    Python: pglast

What are some alternatives?

When comparing vscode-postgres and pglast you can also consider the following projects:

declarative-schemas

libpg_query - C library for accessing the PostgreSQL parser outside of the server environment

codetour - VS Code extension that allows you to record and play back guided tours of codebases, directly within the editor.

sql-parser - A validating SQL lexer and parser with a focus on MySQL dialect.

crystal - 🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!

ANTLR - ANTLR (ANother Tool for Language Recognition) is a powerful parser generator for reading, processing, executing, or translating structured text or binary files.

postgres_lsp - A Language Server for Postgres

pg_query - Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser

nil - NIx Language server, an incremental analysis assistant for writing in Nix.

pg_query_go - Go library to parse and normalize SQL queries using the PostgreSQL query parser

vscode-sqltools - Database management for VSCode

JSqlParser - JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern