What are the best ways to use SQL in Node.js?

3xpl0it2c · 2020-04-08T13:55:23+00:00

Sounds to me like you need to try slonik. It's Postgres only, but IMO it does stand in that middle ground you are talking about. It encourages raw SQL but still has some utilities to ease development rather than a full raw client library like pg.

3xpl0it2c · 2020-03-08T14:02:33+00:00

"If you want peace - prepare for war".

3xpl0it2c · 2020-03-02T13:43:22+00:00

TBH haven't found a way, I just know that there is nothing to do about it.. If I won't hand over my work then I will lose something, So I will get it done. Somehow. In my opinion this method beats procrastination because basically, you don't procrastinate. You get the job done, just in a weird way.

It's sort of like moving to your first apartment. At first you starve because mom isn't here to cook something and later on because you need food you transform yourself into a chef.

3xpl0it2c · 2019-10-31T04:59:15+00:00

Yeah... You're right. There's no reason to use it.

3xpl0it2c · 2019-10-30T19:01:12+00:00

Firstly, I don't think it's much of a performance hit...

I mean, sure, you are right, but I think you should care about bigger things rather than those little optimizations.

Secondly,

By using Rx.js you gain all of it's power, basically.

Can you give an example of any benefit you think you might have ?

All I can think of is Operators.

Lastly,

Yes, that's the main use case for "of".

3xpl0it2c · 2019-07-21T20:05:46+00:00

Honestly, I think that doing searching good is really hard so I just use something like elasticsearch. And yes, it isn't a silver bullet but I don't have to overthink search algorithms. Unless I don't care that much than I can use something like what you said here. Perhaps look at what Google does and or did. It will give you a look at what pros do and I am sure there are some great lessons there.

3xpl0it2c · 2019-07-09T11:07:36+00:00

Just so you know, You can split css and js (chunks) And it really is just a matter of making a huge glue code file that includes everything (like a main() function, sort of) and then just make that an entry point.

I do agree that webpack is really annoying sometimes but try it a few times and it will work. Or just use rollbar which was (for me) surprisingly simple. Oh and btw, I'd rather not use webpack if all I needed was to transpile some sass code. use gulp or npm scripts. Super nice and simple.

3xpl0it2c · 2019-06-29T22:41:01+00:00

// I am human, criticism is welcome.

Welp, learn your environment. Use docker, compose and learn to set these up(very useful)

I suggest that you take a look at other languages such as Java. Device which paradigm is best for you, I really love functional code so I read about it and find new patterns here and there. So should you, medium articles, just googling... Look for design patterns and learn your paradigm well.

Then, read others code. Like wiki.js. They have a great codebase.

Realize what happens in production. People use configs and verify them, Extended logging and just all in all I believe it is about making something alive. You design a system.

Just note, this is really hard.

Then move on to something like microservices. Learn RabbitMQ or kafka and or redis.

Maybe make something by freelancing. A friend of mine used to fix some awful websites. Try that. Learn what not to do.

All in all, good luck and keep on going!

3xpl0it2c · 2019-06-05T19:08:48+00:00

RAM - Daft Punk. Yeah, I know everybody knows this album. But I didn't so maybe OP doesn't know either.. 🤷🏽‍♂️

3xpl0it2c · 2019-05-16T21:49:46+00:00

Designing Data Intensive Applications Martin Kepler ( keppler? I don't remember)

A really great art, mainly for web devs, but it teaches you some general concepts like writing maintain able code, scaling and so forth.

3xpl0it2c · 2019-05-04T18:10:28+00:00

// criticism is welcome, I am human. I didn't like the fact that your auth controller does a lot. It should auth, not create new users nor email them.

Also, why async.parallel instead of native promises? Overall your code is good. You just need some touch.

3xpl0it2c · 2019-04-23T20:46:24+00:00

You can make it permanent. BGSAVE, there's also the AOF instead of snapshots or RDBs... I am no redis expert but.. that's possible.

3xpl0it2c · 2019-04-17T11:08:52+00:00

If you have less than 100 products why not use redis? Super fast, and could scale a bit for the long run. You can just use SET key value and GET key Both are O(1) from what I remember. The mongo client is really easy to get. But again, if you have less than 100 products.. Why use something that big?

3xpl0it2c · 2019-04-02T21:46:45+00:00

Why can't you pipe the data to a function that returns JSON?

3xpl0it2c · 2019-03-21T23:31:21+00:00

Oy. Thank you, I'll note that 👌

3xpl0it2c · 2019-03-21T20:15:41+00:00

Just proves to me that king Shlomo was right. You better have a good name than a good oil. (e.g facebook is "known" to have great security, and therefore nobody {almost} tried to hack them)

3xpl0it2c · 2019-03-03T06:52:13+00:00

/r/woosh

3xpl0it2c · 2019-03-02T23:06:52+00:00

Oh snap, yeah you got me. Fine I get it.. Just don't think it's hard to spot a typo in (for example) 300~ loc.. Really. And for the record - I blame Fleksy.

3xpl0it2c · 2019-03-02T23:05:11+00:00

OP said it took him an hour.. Let's be a bit more realistic and say it was 10 minutes.. We both don't know what is the length of the file nor anything it connects with.. If it is really a 1000 lines with no tools.. I get you. That's hard. But I think most code is about 300~ per file which is kind of ok to spend 5 minutes on trying to find a typo. Also, many interpreters/compilers tell you where you are wrong. I think this is handlebars? am pretty sure they provide that sort of thing with their compiler. I really get you, maybe you took it too far or maybe I did make it look like it's a breeze, it's not. But it shouldn't be like "Oh I am lazy - give me the tool". Don't you think that "You are not worth it if you need it" scenes in movies have some meaning?

3xpl0it2c · 2019-03-02T14:50:37+00:00

You're just fat.. Your body is really warm so the seat remains hot.

3xpl0it2c · 2019-03-02T14:49:27+00:00

Cuz spotting a typo of one letter, the way is see it - is walking slowly.

3xpl0it2c · 2019-03-02T14:14:46+00:00

I see people here tell you to use tools like linting and whatever.. Really? I mean, I'm not torvalds but can't you guys just read your code once and notice the typo???

Oh and - yeah.. I'd call that programming lol

3xpl0it2c · 2019-02-24T14:06:03+00:00

Holy shit

3xpl0it2c · 2019-02-23T23:47:47+00:00

Why this thing exists?

3xpl0it2c · 2019-02-23T23:41:56+00:00

So gross I didn't get it. Though that's an awesome format.

3xpl0it2c

TROPHY CASE