qooleot

8 ms·

31.
by qooleot 12y ago
Hey you do you a middleware you use for this? I'd be interested in trying it out for cases where I have large, semi-static queries and want the entire file to be sql-language and not mixed with node code. Also, how do you handle queri
32.
by qooleot 12y ago
That is invalid in javascript, just like this is invalid: var foo = "string "with quotes" done." You can escape the inner backquotes \` but then its just a backquote character in the string. It doesn't do anything
33.
by qooleot 12y ago
An example of extending your reserved list would be the world "lateral" (new type of join in 9.4). I'll do a PR if I get that far:} RE: comments, yes it would be quoted and that would cause an error. select/ comment &#x
34.
by qooleot 12y ago
I really like knex, and have projects that use it too! Sometimes, and especially on an intranet/admin tool thats not meant for widespread consumption, I start with a sql query (or an analyst hands me one) and it just needs to be a repo
35.
by qooleot 12y ago
Hey yes, sorry if not clear, but I definitely output a prepared statement and do not homebrew any escaping! I'll take a look at adding a "TL;DR" section at the top to point that out before the second page where I actually go
36.
by qooleot 12y ago
Hey nice I actually looked at this library when I started. I really like the sql identifier escaping, where most just do literals. I'd thought about: "select * from %I${my_table} where ..." I think I'd probably feel more
37.
Better SQL strings in io.js(ivc.com)
60 points by qooleot 12y ago|54 comments
38.
by qooleot 12y ago
If you're just trying to get JSON out (for a simple query to REST api, or in a node.js environment), have you considered converting the record/recordset to json in the subquery? The json functions in 9.3+ are pretty handy for that
39.
by qooleot 12y ago
I work on several Django apps, and also write advanced SQL in Postgres (CTEs, plv8 functions, materialized views, etc.). One thing the ORM allows though is writing a custom sql query and its pretty easy to 'cast' the sql results
40.
by qooleot 12y ago
I think by "model logic" he is referring to MVC and things like data model relationships (and an ORM possibly), validation/casting, etc. For example, in a single programming language and framework you could say: payment.isPay
41.
by qooleot 12y ago
This. I'd played with all sorts of leap second adjustments, time zone switching, etc. A really rolling road (Arizona has some of these) where the car might be one "roller" ahead of you but look a lot closer, then your car hit
42.
by qooleot 12y ago
Lets hope they keep momentum, otherwise they'll be 'corkscrewing' the community!
43.
by qooleot 12y ago
Hey nice! One thing I might recommend is independently scrolling the main section from the property editor on the right (have that in a fixed position?). The idea is to be able to see the Navs example when you're changing the padding
44.
by qooleot 12y ago
Hey yes, good catch:} You can email me at taras@ivc.com.
45.
by qooleot 12y ago
No, it can be a gotcha because the json column type (which still exists and many may mistakenly use instead of the jsonb type) allows it: select '{"foo": 1, "foo": 2}'::json; json ------------
46.
by qooleot 12y ago
Since you're planning on doing some conceptual work with JSONB, just a heads upon one gotcha - duplicate properties are not allowed. I.E.: { task: "do stuff", task: "do other stuff" } which sometimes is useful w
47.
by qooleot 12y ago
Sure, statistics in marketing has been around for hundreds of years. I think his key point was alluded to with "just so it would go viral online" as being the new and growing theme. The trick is getting the public at large to spr
48.
by qooleot 12y ago
Cary, NC Software company of 25+ years is looking to fill a Dev Ops position. Responsibilities would include: Setting up, monitoring, and deployment for Node.js, Python applications and databases such as Redis and Postgres. Experience requi
49.
by qooleot 12y ago
Cary, NC Software company of 25+ years is looking to fill a Dev Ops position. Responsibilities would include: Setting up, monitoring, and deployment for Node.js, Python applications and databases such as Redis and Postgres. Experience req
50.
by qooleot 12y ago
By what, hacker news discussions? It seems here only "new" things are discussed, but not as much about platforms growing and stabilizing. Its almost like Rust and Golang have taken over the world if you measure by this communit
51.
by qooleot 12y ago
Just a single data point, but I went to a Redhat talk and their demos had several failing bugs. They also clicked around a lot, and said things like 'well, you now created an ip block, then designated an ip from the pool, but to make
52.
by qooleot 12y ago
Julia's http library, and furthermore the extensive communities around tech stacks like node.js and ruby. Although Julia is focused on mathematical problems, its still often important to pull data from resources on the net (google wea
53.
by qooleot 13y ago
JSON will be getting binary representation. Its just a matter of organizing sponsorship of the project.
54.
by qooleot 13y ago
One glaring miss in the statistical-only approach is that the psychology of a defense on 4th down and how that can impact outcomes. If you just use average net yards-play to extrapolate expected results for 4th down, or 3rd downs as per th
55.
by qooleot 13y ago
Very cool, and awesome on opensourcing the agentredrabbit code! We had a somewhat simpler but related "tons of data coming in via RESTful services and don't want to flood directly to the db with massive parallel connections"