HNHacker News
TopNewBestAskShowJobs

coleifer

2,485 karma · joined November 3, 2009

submissionscomments
coleifer··on Full Text Search with SQLite
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-sqlite-full-text-search-... http://charlesleifer.com/blog/building-the-sqlite-fts5-searc...

coleifer··on Support for indexes that use deterministic expressions
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-python-sqlite-dri...

coleifer··on No One to Rescue Me from My Drinking
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 philosophies and connotes life rather than death.
coleifer··on No One to Rescue Me from My Drinking
Have you ever been to an AA meeting or struggled with addiction? If not then I wouldn't make comments like this.
coleifer··on How to Ace a Phone Screen
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, Albert! I'm glad you like your new job, too :)

coleifer··on SQLite timeline items related to "json"
UnQLite. Not affiliated with SQLite, but its an embedded json document store. Supports a cool procedural query language.

http://charlesleifer.com/blog/introduction-to-the-fast-new-u...

coleifer··on SQLite timeline items related to "json"
Every big feature starts out small.
coleifer··on SQLite timeline items related to "json"
There's code, you can compile it and try it out. For fun I'm thinking to write a little python wrapper:

http://unql.sqlite.org/index.html/wiki?name=UnQL

coleifer··on The SQLite Query Planner
Anybody know how the query planner may change in 4.0?
coleifer··on SQLite Release 3.8.11.1
I wrote up a quick blog post describing how to build the new FTS5 search extension, which was included in the 3.8.11.1 release:

http://charlesleifer.com/blog/building-the-sqlite-fts5-searc...

coleifer··on SQLite Release 3.8.11.1
Anybody heard anything about SQLite4?
coleifer··on SQLite Release 3.8.11.1
Thank you for your work on APSW, it's a fantastic library. I'm the author of the peewee ORM[1] and I've included an APSW backend[2] for folks who want to use peewee with APSW. Being able to write extension modules in Python is such a cool feature! I also made a demo that exposes Redis as a SQLite table[3].

[1] http://docs.peewee-orm.com/

[2] http://docs.peewee-orm.com/en/latest/peewee/playhouse.html#a...

[3] https://github.com/coleifer/peewee/blob/master/examples/redi...

coleifer··on SQLite Release 3.8.11.1
I wrote a post a while back singing the praises of SQLite. Some of you may be interested:

http://charlesleifer.com/blog/sqlite-small-fast-reliable-cho...

coleifer··on Get a Packt Pub book a day for free
That's a good question -- I mean, they will run through the code and make sure it compiles or runs as specified. They will find and provide you with technical recruiters from the community (with promises of their name appearing in the list of technical reviewers). But Packt themselves do not add anything as far as I can tell besides printing and publicizing.
coleifer··on I quit the tech industry
Fuck this guy and his narcissistic post. So you retired early, the hell do I care? Nothing interesting here beyond a guy with the financial means to leave, and who left. Only a narcissist would think this was something profound.
coleifer··on Get a Packt Pub book a day for free
I am actually the author of an as-yet-unpublished book by Packt and have a few things to say about their publishing process. Essentially the quality of the book boils down to the author, with very little in the way of copy-editing or technical reviewing. The quality I would assume varies wildly from book to book, depending on how much time the author was willing to put into it.
coleifer··on [dead]
Wow. JavaScript JavaScript JavaScript. Lame.
coleifer··on Making a toy programming language in Lua, part 2
If you don't get it then I feel sorry for you.
coleifer··on Why I won't be switching to Disque
Hi, I'm the author of this post. First of all thank you for responding to my comments, I'm humbled that you took the time and I apologize if you felt compelled to defend your work.

I was in part responding to the comment in the "Limitations" section of the README about how Disque was developed in "astronaut mode". Mostly, though, my point was that I think many people use Redis as a queue because they want to use Redis as a queue. Maybe it's already part of the stack, or they like the simplicity, whatever.

I am a huge fan of your work and hope to see Disque succeed, again apologies if you felt I was attacking your project.

coleifer··on Follow the White Ball: The torments of snooker’s greatest player
Absolutely incredible the suspense must've been crazy.
coleifer··on Disque – a distributed message broker
I would suggest that one of the reasons so many people use Redis as a message queue is because they do not want another piece of infrastructure. The fact that people use Redis as a message queue does not, in my mind, mean that this is for lack of proven alternatives. I think this is a cool project, but for me, I will stick with Redis.
coleifer··on Show HN: PSequel – a free PostgreSQL GUI Tool for Mac OS X
For SQLite users, I've released a web-based, python-powered database browser: https://github.com/coleifer/sqlite-browser
coleifer··on Quantum OS - OS based on Linux which conforms to Material Design guidelines
Is this in any way related to this project?

http://www.reddit.com/r/unixporn/comments/2mka7r/update_mate...

It's based on Evolve OS.

coleifer··on Representing Trees in PostgreSQL
Another option for storing tree structures is the closure table [1]. It acts as a sort of "many-to-many" junction table between the tree nodes, storing the relationships between each.

[1] https://coderwall.com/p/lixing/closure-tables-for-browsing-t...

coleifer··on SQLite: Small, Fast, Reliable – Choose any three
You can also try out UnQLite, an embedded key/value store and JSON document store:

http://unqlite.org/

I wrote some python bindings using ctypes if you happen to be using python:

http://charlesleifer.com/blog/python-bindings-for-unqlite-an...

coleifer··on SQLite: Small, Fast, Reliable – Choose any three
Very large data-sets:

> An SQLite database is limited in size to 140 terabytes (247 bytes, 128 tibibytes). And even if it could handle larger databases, SQLite stores the entire database in a single disk file and many filesystems limit the maximum size of files to something less than this. So if you are contemplating databases of this magnitude, you would do well to consider using a client/server database engine that spreads its content across multiple disk files, and perhaps across multiple volumes.

Very large amount of traffic:

> SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.

coleifer··on SQLite: Small, Fast, Reliable – Choose any three
From the SQLite docs:

> An SQLite database is limited in size to 140 terabytes (247 bytes, 128 tibibytes). And even if it could handle larger databases, SQLite stores the entire database in a single disk file and many filesystems limit the maximum size of files to something less than this. So if you are contemplating databases of this magnitude, you would do well to consider using a client/server database engine that spreads its content across multiple disk files, and perhaps across multiple volumes.

coleifer··on SQLite: Small, Fast, Reliable – Choose any three
Thank you so much for the comment, I'm glad to hear you've had good luck with SQLite in production. I switched all my personal stuff over to it a month or two ago, haven't looked back.
coleifer··on Give PonyORM a chance
Yes! Plus if you have a syntax error Python will catch it for you. Peewee works the same way.
coleifer··on Give PonyORM a chance
Totally, and I know you are not alone. I think it's just a matter of boundaries, and when it comes to the data access layer of my applications I definitely want to feel very comfortable with the library I'm using. That's why SQLAlchemy is so popular, IMO, the implementation is rock-freekin-solid. The API may be more verbose, but you can understand it, and in doing so trust it to do the right thing.
← PreviousPage 16 of 17Next →