Re: [sqlite] Issue with node-sqlite3
Another datapoint: while the sqlite3 module gets only minimal attention, it
does work fine and we do use it in production for years now.
On Wed, Jun 13, 2018 at 4:26 PM Peter Johnson
wrote:
> Hi Omer,
>
> Unfortunately what you are trying to do it not possible.
>
> You are trying to run the npm package `node-sqlite3` in an Angular project.
>
> Angular is a front-end, browser-based framework.
>
> The npm package manager contains javascript modules which can sometimes be
> used either in the browser or on the command line via nodejs.
>
> In this case, the node-sqlite3 will only work when installed and run in
> nodejs on the command line, it will not work in the browser.
>
> The messages relating to the lack of crypto, http, and https are because
> those modules are part of nodejs and are not available in the browser.
>
> The dependency on make and python are due to node-sqlite3 shipping a
> version of sqlite with the module, it requires those tools
> to compile sqlite.
>
> I hope that helps, this is, unfortunately, the wrong place to report this
> bug.
>
> Please open an issue here for more help:
> https://github.com/mapbox/node-sqlite3
>
> -P
>
> On 13 June 2018 at 12:50, Space Pixel wrote:
>
> > Hi Ryan,
> >
> > I can see you didn't quite understand me. The project I am attempting to
> > install sqlite3 on is an Angular 6 project. Now, in the package sqlite3
> > there is a CS file that spits out a warning "you need an appropriate
> loader
> > to handle this file type". Also, some of the packages sqlite3 requires
> are
> > very ancient and deprecated: crypto, aws-sdk, http, https, and some more.
> > Now, about getting the latest version through the website- again, the
> > "sqlite3" that I'm talking about is a NPM package, and there is nothing
> to
> > do with finding the latest version: I already have it. Plus, when I tried
> > to install it without any Python or build tools, it fell back to the
> build
> > and then the build immediately FAILED. After I installed Windows Build
> > Tools and Python (and added it to PATH), I got it to build successfully,
> > but then I face the problems that I mentioned in the first mail.
> >
> > Hope you understand now,
> >
> > Omer Shamai.
> >
> > On Wed, Jun 13, 2018, 12:52 PM R Smith wrote:
> >
> > > On 2018/06/13 10:26 AM, Space Pixel wrote:
> > > > Hello sqlite community,
> > > >
> > > > I am having serious trouble with the Node.js module "sqlite3". This
> > > package
> > > > is supposed to connect JavaScript or TypeScript code with a sqlite3
> > > > database (file or online database). When I try to use the sqlite file
> > > (the
> > > > command I am using is "const db = new sqlite3.Database("file name
> > > > here");"), it spits out SO many errors regarding packages that were
> > > > declared as deprecated and out of date so long ago. I'm gonna give a
> > log
> > > > below. Notice the warnings: A .cs file spits out a warning, in which
> it
> > > > says: "You need an appropriate loader to handle this file". I tried
> to
> > > find
> > > > a solution for a whole month, to no avail. Please help at once.
> > >
> > > Hi Omer,
> > >
> > > The reason your messages are not being answered quick and precisely is
> > > that this is really not an SQLite issue, it's a CS problem and people
> on
> > > a CS forum are much more likely able to help out. It's also possible
> > > that some CS user here might read it and offer assistance, but so far
> it
> > > didn't attract much attention from such Samaritans.
> > >
> > > The SQLite devs do not make deprecated systems, the stuff can be
> > > downloaded from the SQLite site is all up-to-date and working, so that
> > > means that either CS itself or the wrapper or module you use in CS, to
> > > use SQLite DB capabilities, is out-of-date or deprecated. We can show
> > > you the newest and updated sources for SQLite itself, but we cannot
> > > magic it into your CS project - hence me saying you are far more likely
> > > to get help from a CS forum since someone there is bound to have
> > > discovered and (hopefully) already solved this same problem.
> > >
> > > Once you get the SQLite to be understood by your CS and start using it
> > > and then have any problem with how it works, understands SQL or handles
> > > files, then we can (and would love to) fully assist.
> > >
> > > Good luck,
> > > Ryan
> > >
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
Re: [sqlite] Issue with node-sqlite3
Hi Omer,
Unfortunately what you are trying to do it not possible.
You are trying to run the npm package `node-sqlite3` in an Angular project.
Angular is a front-end, browser-based framework.
The npm package manager contains javascript modules which can sometimes be
used either in the browser or on the command line via nodejs.
In this case, the node-sqlite3 will only work when installed and run in
nodejs on the command line, it will not work in the browser.
The messages relating to the lack of crypto, http, and https are because
those modules are part of nodejs and are not available in the browser.
The dependency on make and python are due to node-sqlite3 shipping a
version of sqlite with the module, it requires those tools
to compile sqlite.
I hope that helps, this is, unfortunately, the wrong place to report this
bug.
Please open an issue here for more help:
https://github.com/mapbox/node-sqlite3
-P
On 13 June 2018 at 12:50, Space Pixel wrote:
> Hi Ryan,
>
> I can see you didn't quite understand me. The project I am attempting to
> install sqlite3 on is an Angular 6 project. Now, in the package sqlite3
> there is a CS file that spits out a warning "you need an appropriate loader
> to handle this file type". Also, some of the packages sqlite3 requires are
> very ancient and deprecated: crypto, aws-sdk, http, https, and some more.
> Now, about getting the latest version through the website- again, the
> "sqlite3" that I'm talking about is a NPM package, and there is nothing to
> do with finding the latest version: I already have it. Plus, when I tried
> to install it without any Python or build tools, it fell back to the build
> and then the build immediately FAILED. After I installed Windows Build
> Tools and Python (and added it to PATH), I got it to build successfully,
> but then I face the problems that I mentioned in the first mail.
>
> Hope you understand now,
>
> Omer Shamai.
>
> On Wed, Jun 13, 2018, 12:52 PM R Smith wrote:
>
> > On 2018/06/13 10:26 AM, Space Pixel wrote:
> > > Hello sqlite community,
> > >
> > > I am having serious trouble with the Node.js module "sqlite3". This
> > package
> > > is supposed to connect JavaScript or TypeScript code with a sqlite3
> > > database (file or online database). When I try to use the sqlite file
> > (the
> > > command I am using is "const db = new sqlite3.Database("file name
> > > here");"), it spits out SO many errors regarding packages that were
> > > declared as deprecated and out of date so long ago. I'm gonna give a
> log
> > > below. Notice the warnings: A .cs file spits out a warning, in which it
> > > says: "You need an appropriate loader to handle this file". I tried to
> > find
> > > a solution for a whole month, to no avail. Please help at once.
> >
> > Hi Omer,
> >
> > The reason your messages are not being answered quick and precisely is
> > that this is really not an SQLite issue, it's a CS problem and people on
> > a CS forum are much more likely able to help out. It's also possible
> > that some CS user here might read it and offer assistance, but so far it
> > didn't attract much attention from such Samaritans.
> >
> > The SQLite devs do not make deprecated systems, the stuff can be
> > downloaded from the SQLite site is all up-to-date and working, so that
> > means that either CS itself or the wrapper or module you use in CS, to
> > use SQLite DB capabilities, is out-of-date or deprecated. We can show
> > you the newest and updated sources for SQLite itself, but we cannot
> > magic it into your CS project - hence me saying you are far more likely
> > to get help from a CS forum since someone there is bound to have
> > discovered and (hopefully) already solved this same problem.
> >
> > Once you get the SQLite to be understood by your CS and start using it
> > and then have any problem with how it works, understands SQL or handles
> > files, then we can (and would love to) fully assist.
> >
> > Good luck,
> > Ryan
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Issue with node-sqlite3
On 13 Jun 2018, at 11:50am, Space Pixel wrote: > Also, some of the packages sqlite3 requires are > very ancient and deprecated: crypto, aws-sdk, http, https, and some more. sqlite3 does not require any of those packages. SQLite has no dependencies at all. You can compile sqlte3 support entirely from one '.c' file and one '.h' file and they don't #include anything else. All SQLite does is store data in files on your own local drive. SQLite does not do any crypto. It cannot access anything over HTTP. It does not understand Amazon Web Services. Something else you're using must require those packages. > Plus, when I tried > to install it without any Python or build tools, it fell back to the build > and then the build immediately FAILED SQLite includes no Python code and cannot be directly called from Python. SQLite itself provides just a C API does not come with any Python interface. Once again, your errors are not coming from SQLite. They're coming from some other part of your development system. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Issue with node-sqlite3
> On 13 Jun 2018, at 11:50am, Space Pixel wrote: > > Also, some of the packages sqlite3 requires are > very ancient and deprecated: crypto, aws-sdk, http, https, and some more. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Issue with node-sqlite3
On 13 Jun 2018, at 9:26am, Space Pixel wrote:
> I am having serious trouble with the Node.js module "sqlite3". This package
Hello Omer.
Then retry your command using just node, with no .cs involved
const db = new sqlite3.Database("file name here");
In other words, make a test.js file containing just this line and execute it
using
prompt> node test.js
If it works, stop here. You have no problem with SQLite.
If it doesn't work download a fresh copy of node from
Re: [sqlite] Issue with node-sqlite3
>I can see you didn't quite understand me. The project I am attempting >to >install sqlite3 on is an Angular 6 project. Now, in the package sqlite3 >there is a CS file that spits out a warning Ryan's advice, though, is still correct: this is not a NodeJS or Angular mailing list. You'd probably have more luck asking in a forum for those technologies first. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Issue with node-sqlite3
Hi Ryan,
I can see you didn't quite understand me. The project I am attempting to
install sqlite3 on is an Angular 6 project. Now, in the package sqlite3
there is a CS file that spits out a warning "you need an appropriate loader
to handle this file type". Also, some of the packages sqlite3 requires are
very ancient and deprecated: crypto, aws-sdk, http, https, and some more.
Now, about getting the latest version through the website- again, the
"sqlite3" that I'm talking about is a NPM package, and there is nothing to
do with finding the latest version: I already have it. Plus, when I tried
to install it without any Python or build tools, it fell back to the build
and then the build immediately FAILED. After I installed Windows Build
Tools and Python (and added it to PATH), I got it to build successfully,
but then I face the problems that I mentioned in the first mail.
Hope you understand now,
Omer Shamai.
On Wed, Jun 13, 2018, 12:52 PM R Smith wrote:
> On 2018/06/13 10:26 AM, Space Pixel wrote:
> > Hello sqlite community,
> >
> > I am having serious trouble with the Node.js module "sqlite3". This
> package
> > is supposed to connect JavaScript or TypeScript code with a sqlite3
> > database (file or online database). When I try to use the sqlite file
> (the
> > command I am using is "const db = new sqlite3.Database("file name
> > here");"), it spits out SO many errors regarding packages that were
> > declared as deprecated and out of date so long ago. I'm gonna give a log
> > below. Notice the warnings: A .cs file spits out a warning, in which it
> > says: "You need an appropriate loader to handle this file". I tried to
> find
> > a solution for a whole month, to no avail. Please help at once.
>
> Hi Omer,
>
> The reason your messages are not being answered quick and precisely is
> that this is really not an SQLite issue, it's a CS problem and people on
> a CS forum are much more likely able to help out. It's also possible
> that some CS user here might read it and offer assistance, but so far it
> didn't attract much attention from such Samaritans.
>
> The SQLite devs do not make deprecated systems, the stuff can be
> downloaded from the SQLite site is all up-to-date and working, so that
> means that either CS itself or the wrapper or module you use in CS, to
> use SQLite DB capabilities, is out-of-date or deprecated. We can show
> you the newest and updated sources for SQLite itself, but we cannot
> magic it into your CS project - hence me saying you are far more likely
> to get help from a CS forum since someone there is bound to have
> discovered and (hopefully) already solved this same problem.
>
> Once you get the SQLite to be understood by your CS and start using it
> and then have any problem with how it works, understands SQL or handles
> files, then we can (and would love to) fully assist.
>
> Good luck,
> Ryan
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Issue with node-sqlite3
On 2018/06/13 10:26 AM, Space Pixel wrote:
Hello sqlite community,
I am having serious trouble with the Node.js module "sqlite3". This package
is supposed to connect JavaScript or TypeScript code with a sqlite3
database (file or online database). When I try to use the sqlite file (the
command I am using is "const db = new sqlite3.Database("file name
here");"), it spits out SO many errors regarding packages that were
declared as deprecated and out of date so long ago. I'm gonna give a log
below. Notice the warnings: A .cs file spits out a warning, in which it
says: "You need an appropriate loader to handle this file". I tried to find
a solution for a whole month, to no avail. Please help at once.
Hi Omer,
The reason your messages are not being answered quick and precisely is
that this is really not an SQLite issue, it's a CS problem and people on
a CS forum are much more likely able to help out. It's also possible
that some CS user here might read it and offer assistance, but so far it
didn't attract much attention from such Samaritans.
The SQLite devs do not make deprecated systems, the stuff can be
downloaded from the SQLite site is all up-to-date and working, so that
means that either CS itself or the wrapper or module you use in CS, to
use SQLite DB capabilities, is out-of-date or deprecated. We can show
you the newest and updated sources for SQLite itself, but we cannot
magic it into your CS project - hence me saying you are far more likely
to get help from a CS forum since someone there is bound to have
discovered and (hopefully) already solved this same problem.
Once you get the SQLite to be understood by your CS and start using it
and then have any problem with how it works, understands SQL or handles
files, then we can (and would love to) fully assist.
Good luck,
Ryan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
