Viewing profile — sehrope

The intended usage is that the client tells the server, " I want to load data from a file /path/to/data.txt on my local filesystem " in a SQL command. As part of the protocol for e…

> PostgreSQL 11 introduces SQL stored procedures that allow users to use embedded transactions (i.e. BEGIN, COMMIT/ROLLBACK) within a procedure. Procedures can be created using the…

UUIDs are fine too. What matters is how they're generated. If you're generating v4 UUIDs server side using the "uuid" NPM module then you're fine as internally it's using crypto.ra…

Hashing a value from Math.random() with a cryptographic hash (i.e. SHA256) doesn't make it cryptographically random[1]. If you want a random string get one directly via crypto.rand…

What's the min version of the Postgres server this can be used with?

I've used WAL-E (the predecessor of this) for backing up Postgres's DB for years and it's been a very pleasant experience. From what I've read so far this looks like it's superior …

Finally! Having dealt with many database drivers over the years, I can say first hand that closed source drivers are the bane of my existence. The only thing worse than running int…

Does this allow users to execute custom SQL, in addition to ORM methods, and have it be part of the same transaction?

I played around with it quite a bit in early 2014 and even wrote a plugin for it. It gave me a better understanding of Docker and abstracting things into containers. The internals …

For me 600 iterations takes about 3ms (I guess my laptop is a bit faster). A decent range to shoot for is .5-1 sec. Test program: crypto = require 'crypto' password = 'testing' len…

From the link: ITERATIONS = 600 ... crypto.pbkdf2 pwd, salt, ITERATIONS, LEN, (err, hash) -> That's way too small for the number of iterations. Something like 100K would be a bette…

> ... and if streams become a better and better option as response sizes get larger and larger. The streams syntax is nicer looking in any case. fs.readFile(...) reads the entire c…

Any background on who's doing this or what the motivation is? The linked site doesn't have much content besides a link to the GitHub repo. EDIT: Even though it's not explicitly lis…

> If your app needs a relational database then use an in-memory db like hsql or cloud services like Heroku Postgres, RDS, Redis Labs, etc. However one risk with most in-memory data…

LATERAL is awesome. It makes a lot of queries that required sub-select joins much simpler to write and later read. It's also great for set returning functions. Even cooler, you don…

Most Postgres clients have issues connecting to Amazon Redshift. The wire protocol is the same so basic interactions ( ex: connect via psql and run a SELECT ) usually works but thi…

> In this trial, XFINITY Internet Economy Plus customers can choose to enroll in the Flexible-Data Option to receive a $5.00 credit on their monthly bill and reduce their data usag…

Oracle supported both full refresh and incremental refresh as of at least 10 years ago ( maybe longer ). Fast refresh requires creating "MATERIALIZED VIEW LOGS" on the source table…

>> Seemed like a good idea until it dawned on me that this means the passwords are stored as plaintext. >There are several ways this can be done without that. >Easiest is if they s…