coleifer

50 ms·

1. 481.▲
   Nginx: a caching, thumbnailing, reverse proxying image server(charlesleifer.com)

   209 points by coleifer 11y ago|57 comments
2. 482.▲
   by coleifer 11y ago

   I wrote a little web based sqlite database manager: https://github.com/coleifer/sqlite-web
3. 483.▲
   by coleifer 11y ago

   I'd be very interested in seeing a comparison between storage engines like rocks, wiredtiger, leveldb, sqlite4-lsm, heck even kyotocabinet and berkeleydb. The comparison would describe what workload each storage engine optimizes for, w
4. 484.▲
   by coleifer 11y ago

   This exists for peewee orm as well: http://docs.peewee-orm.com/en/latest/peewee/playhouse.html#d...
5. 485.▲
   by coleifer 11y ago

   Thanks for the kind words!
6. 486.▲
   by coleifer 11y ago

   Peewee orm supports json, jsonb, hstore, arrays, full text search, server side cursors...
7. 487.▲
   by coleifer 11y ago

   Since he's not using server side cursors, I believe all rows are pulled into ram when the query executes.
8. 488.▲
   by coleifer 11y ago

   What is the pretentious fappery?! Use a tiling window manager and get over it.
9. 489.▲
   Five reasons you should use SQLite in 2016(charlesleifer.com)

   5 points by coleifer 11y ago|0 comments
10. 490.▲
    by coleifer 11y ago

    Sqlite is always a good option if you want in-memory and SQL. Kyotocabinet supports a number of in-memory database types, as does its networked counterpart kyototycoon. BerkeleyDB can be effectively run in memory if you size your cache righ
11. 491.▲
    I, Product (2010)(boingboing.net)

    1 points by coleifer 11y ago|0 comments
12. 492.▲
    Saturday morning hacks: short-to-medium length Python projects(charlesleifer.com)

    1 points by coleifer 11y ago|0 comments
13. 493.▲
    Saturday morning hack: A note-taking app with Flask(charlesleifer.com)

    1 points by coleifer 11y ago|0 comments
14. 494.▲
    by coleifer 11y ago

    I use it all the time, something like 3000 notes now! I integrated a bookmarking app with it (search for bookmarking on my blog if you're curious) so it's a mix of bookmarked pages, notes, to do lists, reminders, and recently I&#x
15. 495.▲
    by coleifer 11y ago

    This looks very similar to the app I blogged about in a series of "Saturday morning hacks" posts. That app did notes, tags, to do lists, email reminders, and used sqlites full text search extension to provide high quality search.
16. 496.▲
    SQLite table-valued functions with Python(charlesleifer.com)

    2 points by coleifer 11y ago|0 comments
17. 497.▲
    by coleifer 11y ago

    This looks like a very cool project. I cloned it and generated the docs, and while the code is certainly well-document, I didn't see any type of high-level narrative or public APIs. Was hoping to see at least a "littleD.h" or
18. 498.▲
    by coleifer 11y ago

    Schools are already hurting so badly from frivolous lawsuits and oversensitive, opportunistic people. Schools are one of the few institutions trying to actually do some good. Don't kick them when they're already down.
19. 499.▲
    by coleifer 11y ago

    A lot of folks may not know, but Peewee has a large "contrib" package full of db-specific extension modules and other neat things called `playhouse`. If you use `pip` to install peewee or clone it from GitHub, the `playhouse` modu
20. 500.▲
    by coleifer 11y ago

    Thanks!
21. 501.▲
    by coleifer 11y ago

    I took a look at EJDB recently and thought it looked like a pretty neat project. One potential gotcha is that it is built on TokyoCabinet which AFAIK is no longer maintained. Looks like they have plans to build a v2, though.
22. 502.▲
    by coleifer 11y ago

    I commented above, but UnQLite is basically SQLite for JSON documents. If you're brave, SQLite has a new JSON extension as well, which looks pretty awesome.
23. 503.▲
    by coleifer 11y ago

    If you want a real self-contained, serverless, zero-config JSON document store, try UnQLite or the new SQLite JSON extension. I've written about both of them on my blog if you're curious: * http://charlesleifer.com&#x2F
24. 504.▲
    by coleifer 11y ago

    Seems like a great opportunity to use SQLite, then folks could share around database files. Why the hell don't more people use SQLite for things like this?
25. 505.▲
    Using the New SQLite JSON Extension with Python(charlesleifer.com)

    1 points by coleifer 11y ago|0 comments
26. 506.▲
    by coleifer 11y ago

    I wrote a fairly detailed post about sqlite full text search with python (1). I also put together some notes of you want to build the new FTS5 extension and give it a whirl (2). http://charlesleifer.com/blog/using-sqlit
27. 507.▲
    by coleifer 11y ago

    Berkeleydb comes with a Sqlite api-compatible library. Using this, you effectively get sqlite with page level locking as opposed to database. Instructions here for compiling: http://charlesleifer.com/blog/building-the-p
28. 508.▲
    by coleifer 11y ago

    I don't think that's true at all. I think the idea of "let go and let god" is about realizing you are not in control, and accepting that (accepting the things you cannot change). This idea is found in many religions and
29. 509.▲
    by coleifer 11y ago

    Have you ever been to an AA meeting or struggled with addiction? If not then I wouldn't make comments like this.
30. 510.▲
    by coleifer 11y ago

    Funnily enough I used to work with Albert Treat at the "biotech startup" in South San Francisco. He's an incredibly talented individual, very driven, and contributed massively to the work done at that company. Great advice, A