Fork me on GitHub
#off-topic
<
2017-10-31
>
mpenet10:10:49

an atreus but close enough. You mean .emacs inspiration?

jmayaalv11:10:44

hey @U050SC7SV atreus is very similar. I’m searching for keyboard layouts (not .emacs)

jmayaalv12:10:49

thank you. 🙂

jakemcc17:10:24

I don’t have anything too interesting going on with my ergodox layout, but my left hand lower thumb keys (from left to right) go space, alt, backspace. And my right lower thumb keys (also left to right) are page down, enter, spacebar. (I don’t really use page down).

jakemcc17:10:58

I haven’t been keeping up with firmwares, but https://jakemccrary.com/blog/2014/09/07/ergodox-turn-on-led-when-not-on-the-main-layer/ is probably my more interesting change, which turns on an LED when not on the main layer.

jmayaalv18:10:37

cool thanks a lot @U06SWJ2RH!

jmayaalv10:11:05

i also got good ideas from here: https://www.youtube.com/watch?v=SiOILU6HdbA u might find it interesting

jmayaalv11:11:59

i particularly liked the idea of having the modifier keys in the home row. after a day i’m really happy 🙂 (finally)

hmaurer21:10:21

Hello! I am looking for a managed database with the following properties, could anyone point me in a direction? It should be: - decently scalable (not google-scale, but it should handle middle-range load well) - pay as you go - managed - can be sql or nosql, I don’t care too much - doesn’t have to provide incredible persistence guarantees, just something good enough

hmaurer21:10:45

the pay as you go bit is important, as it should be cheap to operate under small load

phronmophobic21:10:41

I’ve really come to love embedded databases like sqlite

schmee21:10:52

they’re the opposite of managed though

phronmophobic21:10:56

it’s not managed, but it’s very manageable

phronmophobic21:10:24

in some cases it’s easier to manage than “managed” databases

phronmophobic21:10:00

otherwise, it probably just depends on what hosting you’re using

phronmophobic21:10:11

if you’re on aws, then you can use rds

phronmophobic21:10:43

if you’re on google cloud, they have a few options

schmee21:10:19

with DynamoDB you pay per read and write capacity, so that could be an option

hmaurer21:10:46

@schmee DynamoDB was the only option I could think of. RDS as suggested by @smith.adriane isn’t very granular in its billing; you pay per instance

hmaurer21:10:11

I don’t see how I would use Sqlite if I am running more than one instance of the application

phronmophobic21:10:36

sqlite is not a good option if you have more than one server

hmaurer21:10:01

I would love Google Cloud (which is what is taking me away of DynamoDB a bit) but none of their offers seem to fit the bill except cloud datastore

hmaurer21:10:04

but it seems a bit outdated

phronmophobic21:10:40

I think aws aurora on rds is more of a pay as you go model

phronmophobic21:10:49

>Storage consumed by your Amazon Aurora database is billed in per GB-month increments and IOs consumed are billed in per million request increments. You pay only for the storage and IOs your Amazon Aurora database consumes and do not need to provision in advance.

schmee21:10:31

@hmaurer have you looked at BigQuery or Spanner?

schmee21:10:46

with BigQuery you pay per query, dunno what the model for Spanner looks like

hmaurer21:10:24

@schmee those seem to be priced per instance at start at a very high cost. I am trying to build a cheap architecture for a non-profit educational app. I was thinking of using Cloud Functions to scale on that side, but the database is problematic (I can’t afford upward of 100$ costs per month for no traffic)

schmee21:10:07

you sure? I can’t find any per instance costs for BigQuery: https://cloud.google.com/bigquery/pricing

phronmophobic21:10:03

for cheap options, I’ve used the $5/mo instance on digital ocean using server+sqlite

hmaurer21:10:22

@schmee I am not familiar with BigQuery; it seems to be aimed at big data but it might be suitable for my use-case too

phronmophobic21:10:29

i’ve also used heroku in conjuction with the free tier offerings for their plugins

phronmophobic21:10:36

specifically, clojure + redis

phronmophobic21:10:45

which I’ve had a website running for years

phronmophobic21:10:58

it’s limited to 25MB of data

phronmophobic21:10:04

but it’s been running for free

hmaurer21:10:23

@smith.adriane that’s what I did last year (with digitalocean), but it doesn’t offer a nice path to scaling to multiple instances without managing it myself. I could set up a kubernetes cluster on digitalocean or google cloud and manage my own database though… but it has an upfront cost

hmaurer21:10:47

does heroku have persistence for redis?

hmaurer21:10:19

ah yes it does

phronmophobic21:10:51

just looked at my account. it looks like I was using https://elements.heroku.com/addons/rediscloud

hmaurer21:10:03

yeah actually no way I can use Heroku’s redis offering as a database; it’s prohibitively expensive storage-wise

hmaurer21:10:13

120$/month for 500MB

phronmophobic21:10:39

yea, i’m not sure what kind of load/pricing you’re targetting

hmaurer21:10:41

could use their postgres though, but that would have the same issue as RDS / google cloud sql

hmaurer21:10:52

ideally I would like a pay-per-write/read, like DynamoDB

hmaurer21:10:57

or pay per GB stored

schmee21:10:01

one slightly off-beat option is to use S3 + Athena

schmee21:10:19

S3 costs jack shit for storage, and Athena costs per data scanned per query

hmaurer21:10:22

@schmee yes I was actually just looking at this right now (but with Google Cloud Storage instead of S3)

hmaurer21:10:30

it seems like a viable solution to store JSON documents

hmaurer21:10:38

a bit unorthodox, but heck…

schmee21:10:04

if keeping the costs down is a priority then it is a very viable option

hmaurer21:10:45

@schmee basically, to give you an idea, I am writing an education application for a course at my universitity, which we would like to open up to other universities

hmaurer22:10:16

we need to be able to onboard new universities for free (to encourage adoption), and so the costs for us should be low, and smoothly increase (thus pay-as-you-go)

hmaurer22:10:34

the amount of data could be decently large

hmaurer22:10:50

the course we will be using it on at our university has 400 students, but we would be storing a lot of exercise data and student solutions

hmaurer22:10:58

so it could grow to a couple of GB over the course of the semester

hmaurer22:10:02

and that’s only a single course

hmaurer22:10:33

json blobs on CLoud Storage / S3 seem like a decent solution actually

hmaurer22:10:43

there might not even be a need for Athena if I structure the data properly

hmaurer22:10:48

I don’t really need ad-hoc querying

hmaurer22:10:02

being able to store and retrieve JSON documents quickly should be enough

hmaurer22:10:14

I am not sure what the latency of S3 is if I query it internally (within AWS’s network)

hmaurer22:10:25

but I would hope it will take < 20ms to retrieve a small json doc

hmaurer22:10:52

I just checked and google cloud storage supports optimistic locking, which is good too

schmee22:10:55

latency should be good enough

schmee22:10:17

it is the easiest way to get up and running too

hmaurer22:10:19

have you heard of people using S3 as a database before? just to be sure it’s not something completely stupid to do 😄

schmee22:10:42

people use S3 for anything and everything

hmaurer22:10:01

google cloud storage charges more per write operation

hmaurer22:10:05

but it still cheap it seems

hmaurer22:10:40

0.05$ per 10,000 writes

sundarj22:10:43

how about Firebase?

hmaurer22:10:43

Thank you @schmee 🙂

hmaurer22:10:12

@sundarj yeah I am considering that one too… It seems like a decent option; I need to check how much data I will have (in GB) as firebase can get quite expensive on that side