coleifer

48 ms·

451.
by coleifer 10y ago
I wrote some python bindings to the sqlite4 lsm store: http://lsm-db.readthedocs.io
452.
by coleifer 10y ago
Not the poster, but I did some benchmarks with embedded databases and Python if you're interested in completely useless, unscientific data: http://charlesleifer.com/blog/completely-un-scientific-bench...
453.
by coleifer 10y ago
Where was the useful information? I don't like negative comments as much as the next person, and have written many posts about Sqlite... I'm glad the author of beet uses Sqlite, but to use a client/server database system woul
454.
by coleifer 10y ago
Batching inserts, wrapping the batches in transactions, waiting til after to add indexes: best way to go.
455.
by coleifer 10y ago
I have written several "Use Sqlite!" posts that have made the rounds on hackernews... reading this watered down post, which is devoid of any new, surprising or usable info, it strikes me that repping SQLite has achieved meme statu
456.
by coleifer 10y ago
Regarding concurrency, the folks at Oracle welded sqlites front-end onto berkeleydb. Since bdb does page-level locking you can potentially see much greater concurrency with the bdb implementation.
457.
by coleifer 10y ago
I like to think of it as a thought experiment with some working code attached.
458.
by coleifer 10y ago
It's public domain, so no license necessary. The blessing is awesome though.
459.
by coleifer 10y ago
Succinctly, sqlite3 uses database locks for write transactions. This means only one writer can exist at a time, limiting concurrency. Secondly, sqlite is an embedded database and doesn't have a separate server process.
460.
by coleifer 10y ago
sqlite4 is completely different from sqlite3. The design is interesting in its own right but it's for a completely different product.
461.
by coleifer 11y ago
Who cares, this is some real 4chan bait if you ask me.
462.
by coleifer 11y ago
> author of over 600 modules on npm Nope.
463.
Describing projects as “For Humans” must stop(charlesleifer.com)
2 points by coleifer 11y ago|0 comments
464.
by coleifer 11y ago
Narcissist
465.
by coleifer 11y ago
Seems somewhat of a poor man's peewee, which in turn is a poor man's sqlalchemy. (Author of peewee here)
466.
by coleifer 11y ago
Ackkkk I'm actually rewriting it currently to try and ameliorate the cruft that's crept in since the 2.0 rewrite. I want to say "But wait! If you read the code in a couple weeks it'll be so much better!"
467.
by coleifer 11y ago
It's my pleasure! And thank you for the wonderful libraries, talks, and who could forget those snippets.
468.
by coleifer 11y ago
I'm the author of Peewee and I've been running my blog with Flask, Peewee, gevent and sqlite. It's a very low-impact combination, lightweight and fun to use, although I'm a bit biased.
469.
by coleifer 11y ago
Nice post! I think to put it concisely, you could say it provides namespacing. Unfortunately, when your classes have inheritance, you end up hand-implementing inheritance for the Meta attributes. I've gone back and forth on what's
470.
Measuring Nginx Cache Performance Using Lua and Redis(charlesleifer.com)
2 points by coleifer 11y ago|0 comments
471.
by coleifer 11y ago
2005: http://code.activestate.com/recipes/384122-infix-operators/
472.
by coleifer 11y ago
Lame of you not to link my post from yesterday about putting nginx in front of s3. This post seems clearly to be in response to mine. http://charlesleifer.com/blog/nginx-a-caching-thumbnailing-r...
473.
by coleifer 11y ago
Not at all, I would bet that it was written in response to my post.
474.
by coleifer 11y ago
Yeah, I'm pretty sure I linked to your post. I was going to use your script before I realized I could do everything with plain old nginx.
475.
by coleifer 11y ago
That's a good point. The nginx module can rotate, but I don't know of any built-in support for rotation with respect to exif. You could also use lua and the lua imagemagick bindings and probably see much better performance though.
476.
by coleifer 11y ago
If all you need is crop or resize, might as well use nginx in my opinion.
477.
by coleifer 11y ago
Exactly, thanks frank! :P
478.
by coleifer 11y ago
Thank you, I've updated the post.
479.
by coleifer 11y ago
Thanks, I've updated my post to append the secret key.
480.
by coleifer 11y ago
I stopped using varnish because, after all, my site is just a blog and Nginx is just fine for my needs. It has a single backend server, so there's no load-balancing. Basically, I was already using Nginx to serve static files, and my ca

More ›