coleifer

45 ms·

1. 361.▲
   by coleifer 9y ago

   Drop me an email, you can find it in my profile.
2. 362.▲
   by coleifer 9y ago

   The lack of a datetime data-type hasn't been a problem in my experience. I have, at different times, stored the timestamp as an integer representing number of microseconds since the epoch, or stored in YYYY-mm-dd HH:MM:SS (which sorts
3. 363.▲
   by coleifer 9y ago

   Yeah, Mozilla killed it out of concerns that there was only one implementation (which admittedly has some quirks)...so the question was, do we standardize SQLite and all its quirks? That didn't seem like a good option to them. Plus thi
4. 364.▲
   by coleifer 9y ago

   Sure, but that's got to be a massive download. Probably not really an option for most sites.
5. 365.▲
   by coleifer 9y ago

   Prison is a deterrent, certainly, but it also exists to keep violent folks away from the rest of society so they can't do more harm.
6. 366.▲
   by coleifer 9y ago

   Too bad it's electron. I'm working on a just-for-fun markdown editor using GtkSourceView and GtkWebkit and, despite a slight learning curve getting familiar with gtk, it's been a pleasure to work on. Ugh...electron? Really??
7. 367.▲
   by coleifer 9y ago

   Sad not to see Cython getting a mention in this post. It is a superset of Python, so your vanilla code will run just fine, and you can optimize slow parts to native-speed. It's a fantastic tool.
8. 368.▲
   by coleifer 9y ago

   I find it very straightforward and obvious to use virtualenvs, which support everything this project purports to do. What is this, then? Some porcelain and convention around virtualenvs? Why do I need this?
9. 369.▲
   by coleifer 9y ago

   For that reason we should all be grateful that money doesn't buy happiness.
10. 370.▲
    by coleifer 9y ago

    Why is this not mentioned very clearly in the README? Seems like willful misrepresentation. You might also mention that, if replacing large values that use overflow pages, the file has the potential to grow without bounds as it looks like o
11. 371.▲
    by coleifer 9y ago

    This is pretty cool. As I was reading the code I really wished for an explanation or simple ASCII diagram of the serialization formats for the various node/record types, as well as for the frames/wal format. Given that the poster
12. 372.▲
    by coleifer 9y ago

    Thanks for sharing, I've been interested in finding pure python implementations of storage engines. Another one I came across is whoosh: https://bitbucket.org/mchaput/whoosh/src/a16ebacb47191afaf2d...
13. 373.▲
    by coleifer 9y ago

    My youngest brother is schizophrenic. He describes it like hearing someone invisible talking. Not in a voice he recognizes as his own internal monologue.
14. 374.▲
    Write your own miniature Redis with Python(charlesleifer.com)

    2 points by coleifer 9y ago|0 comments
15. 375.▲
    by coleifer 9y ago

    Same... I think they need a service status page
16. 376.▲
    by coleifer 9y ago

    Thanks so much. You're right, I think some people have written storage engines for rabbit (as well as mongo) but you might have to search for them. The storage api is simple enough you could write your own in an hour or two.
17. 377.▲
    by coleifer 9y ago

    Huey: https://huey.readthedocs.io -- even simpler :) redis or sqlite, mit license, greenlet/thread/process worker model support.
18. 378.▲
    by coleifer 9y ago

    vbwfind.dll, vbmsg.vbx
19. 379.▲
    Going Fast with SQLite and Python(charlesleifer.com)

    4 points by coleifer 9y ago|0 comments
20. 380.▲
    by coleifer 9y ago

    I'm jealous you got to hear Dr. Hipp, that sounds cool. Would love to hear more about the circumstances :) Regarding the LSM engine, you can find all the relevant implementation details here: https://sqlite.org/src4&#x2
21. 381.▲
    by coleifer 9y ago

    There's an easy workaround: rename the table, create new table, insert into/select from.
22. 382.▲
    by coleifer 9y ago

    Check out the changelog...they've added a ton of new stuff. Native json support, completely new full-text search extension, lsm key/value extension, performance improvements. I think they're looking at some changes to locking
23. 383.▲
    by coleifer 9y ago

    The source tree for sqlite3 now contains an extension named lsm1 that contains both the standalone lsm kv database as well as a virtual table extension which allows you to use it directly from sqlite3. Some info on python integration can be
24. 384.▲
    by coleifer 9y ago

    You might also like this library, which allows you to create virtual tables using a very simple API (2 functions). https://github.com/coleifer/sqlite-vtfunc
25. 385.▲
    by coleifer 9y ago

    The docs cover all this and much more. Do yourself a favor and read them. Sqlite is a very capable library and this post is just the tip of the iceberg. https://docs.python.org/2/library/sqlite3.html
26. 386.▲
    by coleifer 9y ago

    It's a hackernews meme. Just ignore it and move on.
27. 387.▲
    by coleifer 9y ago

    I can't even express how much these simple things have changed my life (and the lives of those around me).
28. 388.▲
    by coleifer 9y ago

    Home-grown implementation using PIL to find dominant colors in images: http://charlesleifer.com/blog/using-python-and-k-means-to-fi...
29. 389.▲
    by coleifer 9y ago

    I'd imagine you could accomplish very similar results using SQLite and the full-text-search extension (FTS3, 4 or 5). I believe the SQLite FTS modules support a porter-stemming tokenizer, though you may need to remove stop-words yourse
30. 390.▲
    by coleifer 9y ago

    I don't see a lot of clinically depressed people sticking guns in people's faces. Nor do I think lack of morality has anything to do with addiction. Rather than treat the mind, I believe in treating the spirit.