modeldba / sql-autocomplete Goto Github PK

When I added the lib to my react project I get the error in my browser console:

./node_modules/.pnpm/[email protected]/node_modules/antlr4ts/misc/InterpreterDataReader.js 17:11-24
Module not found: Error: Can't resolve 'fs' in 'D:\frontend\node_modules\.pnpm\[email protected]\node_modules\antlr4ts\misc'

example： select na from tb1 a left join tb2 b a.code=b.code。
Enter na, how to get the table name: tb1 and tb2, more complex sql, may contain nesting, how to get the corresponding table name, query field information through the table name.

@mtriff The project does not fully implement the modelDBA sqleditor code complete feature.

Support compile to generate es5 file

Hi,

Iam only using SQLDialect.PLpgSQL through the following imports
import {SQLAutocomplete, SQLDialect} from "sql-autocomplete";

and using webpack to bundle for production package but it seems the result package include all dialect and even non-used dependencies, please refer to the attached image

is there anyway to fix this and include only dependencies relevant to my imports

I would like to use this library in the browser.

When importing through import { SQLAutocomplete, SQLDialect } from 'sql-autocomplete'
It raises the following error:

> node_modules/antlr4ts/atn/LexerATNSimulator.js:34:23: error: Could not resolve "assert" (use "--platform=node" when building for node)
js     |     34 │ const assert = require("assert");

Is the library meant to work only for node apps? Else, can you please advise. Thanks.

Generate valid autocomplete suggestions for keywords, tables, or columns.

The description says table names and columns are also supported, but how do I set up the DSN?

Hello. Thanks for your package. Unfortunately, I have not been able to use it yet.

"RangeError]: token index 1 out of range 0..0" occurs when a space is encountered in sql string. Well, let's look at an example.
Codesandbox

String "SELECT" works fine.
String "SELECT " throws an exception like RangeError: token index 1 out of range 0..0.

Your examples from the readme file also do not work, but when I cloned the repository and ran the tests, they all succeeded.

Could you please shed some light on this issue?