rpedela

81 ms·

721.
by rpedela 12y ago
I like the whitelist idea. If you have time, maybe you could create an issue or PR which goes into more detail on your thoughts. As for your specific example, I am not sure I understand the issue. The SQL keyword list (reserved list) is onl
722.
by rpedela 12y ago
Cool! Does it automatically escape variables if a prepared statement cannot be used such as variables within the SELECT clause? A similar library which implements Postgres format() for Node: https://github.com/datalanche&#x2
723.
by rpedela 12y ago
Sorta. There were plenty of websites for source code hosting before Github, but they all sucked because you couldn't collaborate or at least not easily. Github focusing on easy-to-use collaboration tools (pull requests and issues) is w
724.
by rpedela 12y ago
I can see how that could happen depending on how it is used, but I don't see how that must happen. Can you elaborate?
725.
by rpedela 12y ago
Postgres supports LISTEN / NOTIFY [1,2], and you can stream a SELECT using COPY or a cursor. 1. http://www.postgresql.org/docs/9.4/static/sql-listen.html 2. http://www.postgresql.org/docs
726.
by rpedela 12y ago
That is why I used the adjective "good". Like you said, just having an automated test suite is not necessarily useful. Let me define what I mean by "good". A good automated test suite has a very high (>90%) coverage o
727.
by rpedela 12y ago
I generally agree with this post. What I have found to be ironic, personally, is that good automated testing often takes a long time to implement and it feels like it takes forever sometimes. However it usually shortens the overall developm
728.
by rpedela 12y ago
The CSV file appears to mix English and French.
729.
by rpedela 12y ago
Interesting. Is there an API or download link? I am having trouble finding one if there is.
730.
by rpedela 12y ago
In that situation, they are still "substandard". Ideally there would be some mentoring process that happens to try and get the employee on the right track. And a good recruiting process should minimize the number of employees who
731.
by rpedela 12y ago
What is the effect of this result, if any, on established theories?
732.
by rpedela 12y ago
Storage is pretty cheap nowadays. I am curious about the business model too but 3GB really isnt much anymore.
733.
by rpedela 12y ago
Private registration usually costs extra, but not with Google domains. That is a compelling reason to me. I also like the clean interface, some of the other vendors have horrible interfaces.
734.
by rpedela 12y ago
WAL replication is currently the official and best supported mechanism for replication. If WAL replication does not suite your particular use case, then that is when to start looking at Slony, Bucardo, etc.
735.
by rpedela 12y ago
Cool, but why is it so expensive? $12 per GB per month? It is hosted on AWS so what does "high-performance" mean?
736.
by rpedela 12y ago
I don't see how this tool automatically introduces impedance mismatch? It is certainly possible depending on how the application is written, but I don't see how it must happen?
737.
by rpedela 12y ago
Yes I agree with using the term namespace instead of PG schema. I have also never understood why the default schema (namespace) is called "public". Why not "default"? Anyway let us say how do I expose multiple namespaces
738.
by rpedela 12y ago
You can. I didn't say you couldn't absolutely, rather there are cases where you can't. Using the schema search path and/or joining multiple tables into a view allows you to query multiple schemas. The internal schema and
739.
by rpedela 12y ago
Overall this is great, and I am thoroughly impressed. I have a couple criticisms though. 1. The API documentation is incomplete. I know this is fairly new, but information about upsert and the other operations mentioned in the intro video w
740.
by rpedela 12y ago
You want to search for "web worker" or "background task" in NPM. One example: https://github.com/audreyt/node-webworker-threads
741.
by rpedela 12y ago
Those type of frameworks are great, but they all have performance limitations. The typical solutions are either find a faster framework or write it by hand. If the issue is that it is blocking the event loop rather than the literal performa
742.
by rpedela 12y ago
In hindsight, it is obvious that bicycle mechanics had a good chance because they succeeded and their design was more like a flying bicycle than a modern aircraft. However I am sure most other people thought it was only possible from groups
743.
by rpedela 12y ago
Chicago to/from any city is great for freight and possibly commuters.
744.
by rpedela 12y ago
I doubt hail storms would be a problem, but tornadoes are another story. Maybe instead of the tube and pylons being exposed, they were covered in such a way that a tornado would go over top rather than through it.
745.
by rpedela 12y ago
I am pretty happy about the addition of ALTER SYSTEM. I haven't tried it yet, but I think it will make automatic failover to a standby easier to implement. Does anyone have experience with this?
746.
by rpedela 12y ago
The SSD EBS claims a default performance of 3 IOPS/GB with a burst of up to 3000 IOPS with a 99% consistency. One of my larger instances uses SSD EBS and so far I am happy with it. In particular, I was very impressed how much faster up
747.
by rpedela 12y ago
Great! Thanks for fixing this so quickly.
748.
by rpedela 12y ago
Why do they need full access (read and write) to my personal user data on my Github account?
749.
by rpedela 12y ago
Sorta. What you say it true, but it is also true that Node isn't multi-threaded because the user does not have access to that thread pool. The user cannot create their own threads to do CPU work unless they go into C/C++ land. In
750.
by rpedela 12y ago
This is great! Proper support for this has been lacking in the Node world. I recommend json-bignum [1] if you need a Node library for JSON serialization that can handle large numbers. For example, retrieving a JSON-formatted row from Postgr

More ›