News for hackers. Stuff that matters.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by bpatrianakos on Thursday December 24, 2015 @02:56PM (#10789406)
No SQLite isn't heavy but I hope you mean for use in development only.

The issue isn't MongoDB is bad and relational DBs are awesome. The real issue is new developers being taught that Mongo and NoSQL in general are the databases you should be using with Node. The problem secondary to that is devs not knowing when each is appropriate.

Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by rlander on Thursday December 24, 2015 @07:46PM (#10790043)
Sqlite can and is widely used in production server-side.

It's about time the "develoment only" myth was laid to rest. Please read the links bellow:

https://charlesleifer.com/blog/sqlite-small-fast-reliable-ch...

http://stackoverflow.com/questions/1711631/improve-insert-pe...

http://stackoverflow.com/questions/784173/what-are-the-perfo...

Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by cdcarter on Thursday December 24, 2015 @03:21PM (#10789473)
SQLite is the most widely deployed database engine out there.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by jchrisa on Thursday December 24, 2015 @06:38PM (#10789931)
Especially if you count all the phones and copy machines and AV equipment. Embedded databases are fun to code with.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by coderdude on Thursday December 24, 2015 @05:12PM (#10789733)
Not in production it isn't.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by muzmath on Thursday December 24, 2015 @05:40PM (#10789806)
It's actually commonly used in production for certain types of databases. SQLite is not a replacement for something such as postgresql but it certainly has it's use cases.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by coderdude on Thursday December 24, 2015 @05:46PM (#10789820)
Do you mean for public facing sites? If so, what are the use cases?
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by muzmath on Thursday December 24, 2015 @06:19PM (#10789893)
The use case for SQLite isn't high traffic public facing webpages. Here is their own list of 'famous' users: https://www.sqlite.org/famous.html

Every iPhone, and Android phone have SQLite running on them, which easily makes it the most used production database. It's use case is typically very low traffic websites or as client side storage.

Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by coderdude on Thursday December 24, 2015 @07:26PM (#10790004)
Maybe I'm missing something but is Mongo in use on the client side in that same way? If not then SQLlite is being shoehorned into the discussion and the context in which production was used should be clear. I feel like people are trying to be technically right instead of following the actual discussion. I never meant client side software and definitely didn't mean someone's micro traffic blog, where a toy database could be used.

It is interesting how much penetration SQLlite has on the client, though.

At any rate, I know better than to not be extremely specific so I brought this on myself.

Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by smt88 on Thursday December 24, 2015 @09:41PM (#10790241)
It seems like there have just been some assumptions going both ways.

This all started when someone trashed RDBMS for being "heavy", implying that Mongo is good because it's light.

Why would you care how heavy a DB is if it's not on the client side? The kind of memory and storage you need for even the heaviest popular RDBMS (MySQL?) is still low enough that's nearly free to create a small app.

Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by muzmath on Thursday December 24, 2015 @09:50PM (#10790256)
The only reason I brought it up is that there is a myth that many developers believe SQLlite is only useful as a dev enviroment database
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by collyw on Friday December 25, 2015 @01:49AM (#10790600)
On a multiuser system, that's a reasonable assumption.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by muzmath on Friday December 25, 2015 @11:47AM (#10791608)
That's partially true, but it does seem to find it's way in production on lots of low traffic sites.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by progx on Thursday December 24, 2015 @05:25PM (#10789755)
My browser tell me something other.
Re:Show HN: Scaffold App for Node.js, Express, Jade, Passpor... by coderdude on Thursday December 24, 2015 @05:38PM (#10789798)
I don't mean 'on the desktop' when referring to database use in production.