ksri

12 ms·

61.
by ksri 10y ago
In clauses are blown up. I have now added that to the documentation - see https://github.com/hashedin/jinjasql#handling-in-clauses Skipping in clauses altogether - for now, you can handle that using an if condition.
62.
by ksri 10y ago
If you have dynamic table or column names, you can use the |sqlsafe filter. The library will not bind the values in that case, but you've to be sure there's no sql injection in there.
63.
by ksri 10y ago
You can, the tool won't prevent you from doing so. It does however give you the |sqlsafe filter. Using that filter will append the value directly. You can use it to insert dynamic table or column names. Of course you've to be sure
64.
by ksri 10y ago
It does support 3.x, there are test cases for it as well. I'll fix the readme, thanks for pointing that out!
65.
by ksri 10y ago
It doesn't prevent you from using them. You simply get a sql statement with appropriate place holders. You can pass that sql statement to your database library and it will do the right thing - including binding the parameters and creat
66.
by ksri 10y ago
I plan to add those macros in due course. Common where/and macros, utilities for date time manipulation are the ones that top the list.
67.
by ksri 10y ago
It doesn't append the strings blindly. Any variables are automatically replaced by placeholder strings. You also get an array of bind parameters. You then use your database library to bind the parameters into the placeholders.
68.
Show HN: JinjaSQL – Generate SQL Queries using a Jinja Template(github.com)
77 points by ksri 10y ago|38 comments
69.
by ksri 10y ago
I'd love to get HN feedback on a library I wrote to make SQL more manageable - https://github.com/hashedin/jinjasql . The library is built on the Jinja template engine. You can create macros, functions and other re
70.
by ksri 10y ago
While ORMs solve 80% of the needs, you still need the power and flexibility of SQL for those 20% of the needs. Anytime you need reporting, complex joins or aggregation - SQL is a natural choice. But generating dynamic SQL by hand is error p
71.
JinjaSQL – Templating Language to Generate SQL Statements(github.com)
7 points by ksri 10y ago|1 comments
72.
Authentication Techniques for APIs(docs.google.com)
2 points by ksri 10y ago|0 comments
73.
by ksri 12y ago
Why not simply let DNS handle the routing and load balancing? Bring up another HAProxy with the new configuration. Then swap the new and old IP addresses in DNS. Wait for DNS to propagate. When traffic on old HAProxy is zero, bring it down.
74.
Analytics on the Cheap(0x74696d.com)
78 points by ksri 12y ago|27 comments
75.
Redis 3.0.0 beta 3 is out(groups.google.com)
2 points by ksri 12y ago|0 comments
76.
by ksri 14y ago
Definitely makes sense! I'll start looking into this.
77.
by ksri 14y ago
antirez - Author of redis-rdb-tools here. Would you be interested in a patch that adds profiling support to redis-cli? My approach is to parse the rdb file so that the running server isn't affected. It approximates memory usage, but is fair
78.
Magical Number 7 - Limits on our Capacity to Process Information(musanim.com)
1 points by ksri 14y ago|0 comments
79.
by ksri 14y ago
Redis now has several scripts for various analysis. This is a right time to build a user interface that clubs together all these various utilities. 1. Query Analyzer based on Redis-faina, with the ability to grep only a subset of commands o
80.
by ksri 14y ago
Trello uses Redis' pubsub - http://blog.fogcreek.com/the-trello-tech-stack/
81.
by ksri 14y ago
Great job antirez and Pieter! Super excited because of what's not mentioned in the release notes. With 2.6 out of the door, I am sure antirez and Pieter can concentrate on redis sentinel (for high availability) and redis cluster.
82.
Redis 2.6.0 RC1 Released(raw.github.com)
77 points by ksri 14y ago|14 comments
83.
Show HN : Analyze Redis Memory Usage(github.com)
2 points by ksri 15y ago|0 comments
84.
Convert Redis dump.rdb files to JSON(github.com)
2 points by ksri 15y ago|0 comments
85.
Redis RDB File Format Explained(github.com)
1 points by ksri 15y ago|0 comments
86.
by ksri 15y ago
Exactly. Its a matter of spending a few hours per browser to perfect it. For all we know, someone may already have perfected it and could be using this in the wild.
87.
by ksri 15y ago
The webtiming paper provides more information on this form of attack - http://sip.cs.princeton.edu/pub/webtiming.pdf The summary of the paper makes me sad - > We are not aware of any practical countermeasures to these attacks. There s
88.
I know the websites you visited(lcamtuf.coredump.cx)
84 points by ksri 15y ago|46 comments
89.
by ksri 15y ago
>> With so many startups, there are often several choices in any given category. And having several choices is a great thing. When I integrate with an external API, I look at 2-3 other APIs as well. I then write an interface based o
90.
by ksri 15y ago
h) I entered my credit card details and submitted, but couldn't proceed because zip code and state are mandatory. I do not stay in the US, so those fields don't make sense to me. You are alienating non US citizens.

More ›