Thank you, I will look more closely at the node-sqlite3 documentation.
Bob
On 12/31/13, 12:25 AM, Navaneeth K N wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Hello,
On 12/31/13 8:18 AM, Bob Cochran wrote:
I'm working on a tough project that requires me to use Node.js and
SQLite. I'm building a database with SQLite version 3.8.2.
My question is, would purchasing the book "Using Sqlite" by Jay Kreibich
still be mostly pertinent to SQLite 3.8.x features? Would it be helpful
in the context how Node.js is used? I realize that Mr. Kreibich was
writing the book and bringing it to publication just as Node.js was
being invented in 2009.
Does anyone know if this book will be updated?
Or is there a different book title I should look at?
- From my personal experience, you don't need a book to learn/use SQLite.
It is very well documented and pretty easy to get started. If you are in
doubt at anytime, get on the interactive SQLIte console and try out
commands directly on the database.
Right now, my major difficulties seem to be in my own grasp of
asynchronous programming. It is my own deficient grasp of the logic
problems that are biting me; I need to "get it" and understand Node
style programming. An example is: I need to insert two rows to an SQLite
table, but because I'm using non-blocking interface software to do the
actual inserts, and I'm probably using that software incorrectly, only
one insert is being done.
You need to do one insert, then in the success callback of the insert,
do the second insert.
If you use `node-sqlite3`[1], then it allows you to serialize the query
execution in which case it is simpler.
[1]: https://github.com/mapbox/node-sqlite3
Thanks
Bob Cochran
Greenbelt, Maryland, USA
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- --
Cheers,
Navaneeth
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: GPGTools - https://gpgtools.org
iQEcBAEBCgAGBQJSwlUyAAoJEHFACYSL7h6kUCwH/0tMAKjgGldSPeXWKyMT3j8t
X8br4nLyyxsEUa0xASm6S7jiPrwQ8D1IKEjSu1cbX4AAimZSzeMXnIlwyuKVxF7Q
1NLNknzei/LKM1m+jwRYtC6Pencm4o2Jnrc5kcKBrXAh/M4w6r+7Z1dpBN7LK/wP
RZs42203DoV2V4/0FxoBP9OxgdP+AKSYRf4UrOqJM5XZiPVaoi9J43MqRyldwUaU
0n9cTlGzFqgKMxyQgq4cqoQKM9BztvAxkq5jU72FJHXg/3N6tJennL/ACrf2qkff
G5rSdb0SDOUAvajy8cybRj90F2e3E+3C6uvrph7UdD/86A4PitzKnezFw2y72L4=
=gKGL
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
