01:23:06  <danneu>jammi: check out http://knexjs.org/ for generating sql
01:23:39  <danneu>well, not sure if that was a question
01:47:47  <jammi>it's not. haven't really found a reason to return to sql databases
02:52:12  * TheThingjoined
02:52:35  * TheThingquit (Remote host closed the connection)
03:19:58  * Limixjoined
03:26:04  * Limixquit (Quit: Limix)
04:55:56  * Cohedrinquit (Quit: My Mac has gone to sleep. ZZZzzz…)
05:02:40  * Limixjoined
05:10:19  * joshonthewebjoined
05:22:02  * Limixquit (Quit: Limix)
05:24:07  * Cohedrinjoined
05:24:07  * Cohedrinquit (Client Quit)
05:25:37  * Cohedrinjoined
05:28:37  * Limixjoined
05:36:32  * Limixquit (Quit: Limix)
08:34:39  * Cohedrinquit (Quit: My Mac has gone to sleep. ZZZzzz…)
10:09:05  * Sharaalquit (Ping timeout: 250 seconds)
10:11:27  * Sharaal1joined
10:11:32  * Sharaal1quit (Read error: Connection reset by peer)
10:13:16  * Sharaaljoined
10:14:09  * Sharaalquit (Read error: Connection reset by peer)
10:14:52  * Sharaaljoined
10:17:03  * joshonthewebquit (Quit: Computer has gone to sleep.)
10:18:35  * Sharaal1joined
10:18:35  * Sharaal1quit (Client Quit)
10:19:03  * Sharaalquit (Ping timeout: 240 seconds)
10:19:56  * Sharaaljoined
10:23:27  * TheThingjoined
10:31:52  * ArchNoobquit (Ping timeout: 258 seconds)
11:10:36  * TheThing_joined
11:10:36  * TheThingquit (Read error: Connection reset by peer)
11:10:40  * TheThing_quit (Remote host closed the connection)
12:30:37  * ArchNoobjoined
13:18:16  * TheThingjoined
13:19:15  * TheThingquit (Read error: Connection reset by peer)
13:52:18  * Limixjoined
14:13:29  * Limixquit (Quit: Limix)
14:23:46  * felixjetquit (Quit: Leaving)
14:25:25  * felixjetjoined
14:26:46  * Limixjoined
14:28:07  * Limixquit (Client Quit)
14:36:12  * demonshrederjoined
14:40:30  * demonshrederquit (Client Quit)
14:46:32  * DrMabusejoined
16:00:35  * DrMabusequit (Remote host closed the connection)
16:48:21  * Cohedrinjoined
16:58:23  * lucasbjoined
17:01:24  * DrMabusejoined
17:05:57  * DrMabusequit (Ping timeout: 250 seconds)
17:21:12  * Limixjoined
18:02:09  * DrMabusejoined
18:06:37  * DrMabusequit (Ping timeout: 250 seconds)
18:46:18  * ArchNoobquit (Ping timeout: 265 seconds)
19:02:52  * DrMabusejoined
19:07:36  * DrMabusequit (Ping timeout: 276 seconds)
20:00:59  * Limixquit (Quit: Limix)
20:03:42  * DrMabusejoined
20:05:25  * DrMabuse_joined
20:05:26  * DrMabusequit (Read error: Connection reset by peer)
20:08:03  * TheThingjoined
20:10:14  * DrMabuse_quit (Ping timeout: 260 seconds)
20:25:13  * ArchNoobjoined
21:06:09  * DrMabusejoined
21:11:06  * DrMabusequit (Ping timeout: 276 seconds)
21:41:42  * TheThingquit (Remote host closed the connection)
21:56:10  * TheThingjoined
22:06:53  * DrMabusejoined
22:11:43  * DrMabusequit (Ping timeout: 265 seconds)
22:20:00  <dmarr>danneu: i'm tasked with building a usage tracking tool for my app
22:20:17  <dmarr>danneu: i wonder if that schema you have for tracking users would be flexible to do what i want
22:21:35  <danneu>it's a pretty standard yet minimal schema
22:33:38  * TheThingquit (Ping timeout: 258 seconds)
22:47:34  <danneu>the project started out as a minimal koa app that i'd clone and start hacking on whenever i started a new project. it evolved into more of a cookbook. for example i don't need rate-limiting on every project, but i'll paste it from koa-skeleton when i do want it and then modify it from there.
22:47:44  <danneu>same with pagination
22:48:17  <danneu>things that are annoying to implement from scratch but not so sophisticated i'd want a library for
22:51:31  <dmarr>cool, makes sense
22:51:40  <dmarr>do you have an example of a db query that uses pagination
23:07:38  * DrMabusejoined
23:11:47  * DrMabusequit (Ping timeout: 244 seconds)
23:23:04  <danneu>https://github.com/danneu/koa-skeleton/blob/master/src/db/index.js#L191 in koa-skeleton i just use limit/offset https://github.com/danneu/koa-skeleton/blob/master/src/db/index.js#L191
23:23:13  <danneu>didn't mean to paste twice
23:24:08  <danneu>here i use the paginator https://github.com/danneu/koa-skeleton/blob/master/src/routes/index.js#L162
23:25:16  <danneu>obviously to get the total item count you can do a COUNT query on the database. though it's typically something i'd want to cache since COUNT can be expensive on some databases (like postgres) once the table gets big