Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
wulczer
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
12 ms
·
121.
▲
by
wulczer
15y ago
Crap, I'm working on something exactly like this :D Was about to upload it to Github just today, but still wanted to fix a few things. Yours looks quite more finished, one thing that would be very useful is handling Python to Postgres type
122.
▲
by
wulczer
15y ago
Amen. There's already a well-proven and quite expressive DSL for accessing data stored in a relational database: SQL. I see that this has been submitted before, so I'll just mention it here: http://thoughts.j-davis.com/2011/09/25/sql-the-s
123.
▲
by
wulczer
15y ago
Ooops! Sure, you'll have yours today. You had a bit of rotten luck, as precisely on that day we turned down the flow of invites. Sorry to keep you waiting ;)
124.
▲
by
wulczer
15y ago
This photo of two of the founders when they were 12 years and 60 pounds younger should explain it http://dl.dropbox.com/u/18461275/Ducksboard-founders.jpg Go, Anaheim Ducks!
125.
▲
by
wulczer
15y ago
We have plans to make an interface that's less bling-heavy and more power-friendly, but it won't hit production anytime soon. Another way is to simply write your own visualisation. If you're interested in getting early-alpha-unstable-omg ac
126.
▲
by
wulczer
15y ago
Nope, we push changes to clients. The exact workflow is: the initial data is pulled over HTTP, the code connects to our server over WebSockets and after that no more requests are made. The real-time updates are pushed over the WebSocket c
127.
▲
by
wulczer
15y ago
If you have any questions, I'll be here all day ;)
128.
▲
We have a real-time API and we're not afraid to use it. Are you?
(ducksboard.com)
84 points
by
wulczer
15y ago
|
34 comments
129.
▲
by
wulczer
15y ago
Also known as Poor Man's Profiling (see http://poormansprofiler.org/ or http://webcache.googleusercontent.com/search?q=cache%3Apoorm... as it seems the site's down). It's a pretty good technique, actually.
130.
▲
by
wulczer
15y ago
What? A join requires all of your data to be in memory? I've sure as hell seen databases that executed queries with joins and the data was not entirely in memory...
131.
▲
by
wulczer
15y ago
Example A field accepts a username. A good regex would be to verify that the data consists of the following [0-9a-A-Z]{3,10}. The data is rejected if it doesn't match. I guess then that pg won't be able to sign up for your ser
132.
▲
by
wulczer
15y ago
Also see the Mandelbrot set in SQL: http://wiki.postgresql.org/wiki/Mandelbrot_set
133.
▲
by
wulczer
15y ago
Erm, so if things are fast it doesn't matter and if things are slow you should write a whole new service, put a HTTP interface into it and use that? Not sure I buy that :) Disclaimer: I wrote an async DB module for Twisted/PostgreSQL and it
134.
▲
by
wulczer
15y ago
That sounds wrong. You need async database access so that while you're waiting for a query to finish, you can still process other requests. Imagine an app that receives an HTTP request every second. One in five of these requests requires ma
135.
▲
by
wulczer
15y ago
Raphael is for generating SVG, so you can draw anything with it. Oh, and multiplayer browser games were possible long before Node.js appeared, there's no new magic there.
136.
▲
by
wulczer
15y ago
A short, probably biased and not 100% precise answer would be: no, you don't need to look for a commercial RDBMS. The real answer is: always evaluate options. Make sure the solution you choose supports everything you need and that you will
137.
▲
by
wulczer
15y ago
Here's the presentation from last year's PGCon, it's not exactly easy to follow, but has some hints on how this can be used: http://www.pgcon.org/2010/schedule/events/227.en.html
138.
▲
PostgreSQL 9.1 released
(postgresql.org)
284 points
by
wulczer
15y ago
|
45 comments
139.
▲
by
wulczer
15y ago
The problem is not having to update tons of records, the problem is seeing one day, after 2 years of having the app in production, that the listing shows that employee X works in department Y and her boss is Z, but Z is not the head of Y. B
140.
▲
by
wulczer
15y ago
ipfw :o)
141.
▲
by
wulczer
15y ago
Probably not, Python's reload has its fair share of caveats. There was an effort in Twisted to provide robust reloading support for Python modules[1], but I think it's a bit abandoned. That being said, we are using reload() with manhole t
142.
▲
Runtime code modification. Erlang? No, Python
(blog.ducksboard.com)
41 points
by
wulczer
15y ago
|
17 comments
143.
▲
by
wulczer
15y ago
Twisted has semi-decent documentation, see http://twistedmatrix.com/documents/current/api/twisted.html http://twistedmatrix.com/documents/current/core/howto/index.... http://twistedmatrix.com/trac/wiki/Documentation It's not as compre
144.
▲
by
wulczer
15y ago
A typical usage of volatile, and one that bit me many times is using longjmp, for which the man page says: The values of automatic variables are unspecified after a call to longjmp() if they meet all the following criteria: · they are
145.
▲
by
wulczer
15y ago
I think #define volatile is by far the sneakiest. The rest would probably be found quite quickly, but omitting volatiles could lead to hard to detect bugs that will only manifest themselves under specific circumstances.
146.
▲
by
wulczer
15y ago
Yep, you can disable individual warnings with pragmas ( http://gcc.gnu.org/onlinedocs/gcc/Diagnostic-Pragmas.html ) so if I add #pragma GCC diagnostic ignored "-Wunused-parameter" to the C file, I get warningless compilation even wit
147.
▲
by
wulczer
15y ago
I don't get any warnings with -Wall and I get a "unused variables argc and argc" with -Wextra. Changing main's signature to int main() eliminates all warnings at -Wextra.
148.
▲
by
wulczer
15y ago
Interesting, I just tried compiling this with gcc 4.4.5 and got no warnings: #include <stdio.h> #define ADD(x, y, z) \ do { \ z = x + y; \ } while (0) int main(int argc, char *argv[]) { int z; ADD(1, 3,
149.
▲
by
wulczer
15y ago
A common idiom to use here would be for(;;) {...}
150.
▲
by
wulczer
15y ago
Right now it's more useful for uncovering bugs, I don't think anyone would recommend running Postgres compiled with clang on a production system. For more info about performance, see http://pgeoghegan.blogspot.com/2011/07/could-clang-displ
More ›