node-sql | SQL generation for node.js | Runtime Evironment library

I am trying to open a sqlite3 database encrypted with sqlcipher. I have the password and I could open it successfully using sqlitebrowser.

I started my project using this template. It is based on the electron-forge webpack plugin.

When I type yarn start, it creates a .webpack folder and all the compiled code goes in it. When I stop the terminal command, this folder disappears.

Then I wanted to use the package @journeyapps/sqlcipher to open my database, but this line is causing an error in the main process: const sqlite3 = require("@journeyapps/sqlcipher")

The error is: Error: Cannot find module '<>/.webpack/main/native_modules/lib/binding/napi-v6-linux-x64/node_sqlite3.node'

The package documentation says two things about using it with electron-forge:

1. make sure that the folder node_modules/@journeyapps/sqlcipher/lib/binding/napi-v6-linux-x64 exists -> yes it exists

2. Disable rebuilding of this library using the onlyModules option of electron-rebuild in your package.json "config": { "forge": { "electronRebuildConfig": { "onlyModules": [] // Specify other native modules here if required } } -> I did it, I added the lines of code

I still have the error, but I feel it can be solved "easily" (with a lot more understanding of webpack than I have). Indeed, a solution would be to move the folder binding/napi-v6-linux-x64 into .webpack each time I launch the app, right?

I tried to do electron-rebuild -f -w sqlite3, the rebuild succeeded but nothing happens, I still have the same error.

I am stuck here and cannot go further for my app, as it lays on reading this database. Should I start a new project and avoid using webpack? Do you have any example of a project where this package is successfully imported and used?

Thank you in advance for your help!

I've been trying to download sqlite3@4.2.0, however it's been giving me an error. Here are the logs when trying to run npm install:

I'm using better-sqlite3 on Node, but I suspect my questions are applicable to node-sqlite3 as well.

I basically have 2 simple questions, relating to a server-rendered website:

• Do I need to explicitly call .close() on the database? I seem to remember reading somewhere that it will automatically close when the current scope (like the current function) exits. What if I never call .close() in a web server scenario, taking a lot of requests?

• If you have a bunch of different components (authentication, authorisation, localisation, payment, etc...) and each component may or may not need to access the database throughout the lifetime of a request (which are quite short-lived, except for payment), is it better to

  1. have one db connection for the lifetime of the server and pass that around
  2. have one db connection for the lifetime of the request and pass that around
  3. open a new connection every time I need something, maybe 2-3 times per request (and close it either explicitly or implicitly when the function returns, if that's a thing)

Thank you

My aim is to parse SQL (specifically Hive) statements with javascript, preferably Nodejs. I started out with node-sql-parser which looked promising. However I found quite a few cases where the parser did not recognize valid SQL like several nested functions on a column in a select clause, and multiple AND clauses in SQL that had lots of joins, unions, etc. (I've logged as issue but it will take some time).

I decided to look at Antlr v4. I followed the getting started steps with Hive SQL grammar. (https://github.com/apache/hive/blob/master/hplsql/src/main/antlr4/org/apache/hive/hplsql/Hplsql.g4); I generated parsers lexers and listeners using Antlr's generation for JavaSCript - all good so far. Then I tried a simple test as below:

I want to install pyproj on Debian on Docker.

This is my script:

I'm programming a website to search in a sqlite database. I'm using node-sqlite3 in my backend, this is my code.

I am using node-sql for communicating with my SQL Server. I am trying to configure the connection using the following:

I'm struggling with some basic async/await problem in node.js using node-sqlite3.
My objective is to select some value from SQLite DB, check it for some condition and take some actions in case the condition is met. Here's the code:

I'm using node v14.2 and sqlite3: https://github.com/mapbox/node-sqlite3

I'm trying to determine if a table exists, and if it does, make a query against it. I've tried: