HNHacker News
TopNewBestAskShowJobs

coleifer

2,485 karma · joined November 3, 2009

submissionscomments
coleifer··on UnQLite – An Embeddable NoSQL Database Engine
I authored a python binding and have some experience that may be relevant.

The library seems poorly maintained in my opinion and might be abandoned. There have been critical bugs leading to data loss. They have a similar project vedis which is like an embedded redis that I think is completely abandoned.

For the love of God just use SQLite if you want an embedded database for structured data, even if it's just eav. If you just need key/value there are battle-tested, well maintained options.

https://github.com/symisc/unqlite/issues/41

coleifer··on UnQLite – An Embeddable NoSQL Database Engine
I'm the author of that library. I've worked to make sure all the unqlite features are available (transactions, cursors, jx9 vms, collections) and the interfaces are pythonic. Performance is good. Why not submit issues or patches instead?
coleifer··on Evidence that addictive behaviors have links with ancient retroviral infection
I think addiction is: you can't moderate usage even when you want to, and can't stay stopped even when you want to.
coleifer··on Evidence that addictive behaviors have links with ancient retroviral infection
AA is sometimes jokingly referred to as the last house on the block (NA is the last room in that house).

I know a great many recovered individuals that tried everything to get clean and only found success (and more importantly satisfaction) in 12 step.

coleifer··on Alex Garland’s cult novel The Beach, 20 years on
The movie is based on the first book in a trilogy. Really weird, almost surreal sci-fi. Definitely enjoyed both the books and the movie.
coleifer··on Most Doctors Are Ill-Equipped to Deal with the Opioid Epidemic
Treating addiction as a disease in it's own right seems like a good place to start. If the drug seeking, dishonesty, etc, are symptoms of an underlying disease, wouldn't it be best to treat the cause rather than fiddling with the symptoms? What would such a treatment plan look like, I wonder?
coleifer··on Host Your Blog on DigitalOcean with Docker, Nginx and Let’s Encrypt
Premature optimization something something...and honestly this isn't even optimization, just some extra complexity.

Dockers cool for doing dev stuff on your laptop, or for scaling out with something like kubernetes. This is just silly!

coleifer··on SETI spots dozens of new mysterious signals emanating from distant galaxy
Please let it be aliens
coleifer··on Tables
Love lua. Luajit is stupid fast and the ffi stuff makes it a snap to integrate with other libraries. You can find Lua in neat places like nginx, redis, tokyotyrant...

I dislike the direction python has been going (twisted...i mean asyncio, type annotations, f strings). Lua is like a breath of fresh air.

Downsides are small standard library and 1-based indexing shudder.

coleifer··on LOLWUT: a piece of art inside a database command
antireZ...that's just awesome. Thanks for restoring my faith in the hacking mentality once again.

Even cooler apropos of the stuff he alludes to on Twitter last week.

coleifer··on The Effectiveness of Publicly Shaming Bad Security
So an eye for an eye, huh?

The thing is, publicly shaming someone is a very lazy way to effect change. Sure it might work for corporations, but if there's resistance it may be necessary to try reaching out to the decision makers via a different communication channel. I don't think it's appropriate to ratchet up the shaming and outrage.

coleifer··on The Effectiveness of Publicly Shaming Bad Security
I have compassion for these people who made these ludicrous comments -- they clearly aren't cryptographers or digital security experts. Let's separate the people making these comments from the corporations they represent.

Public shaming of a person is never the right response, in my opinion -- live and let live.

Public shaming of a corporation, on the other hand, may be the only way to get the attention of the decision-makers.

Let's be kind and compassionate to individuals.

coleifer··on OxyContin billionaire has patented a drug to wean addicts from opioids
There was a prominent doctor here in Topeka who was fired from the hospital for keeping folks on Suboxone. The idea of course is that you can have a nice gentle taper, same with methadone, but the reality is you can't "beat" withdrawal. So people stay on it. The euphoria from these drugs doesn't come close to heroin, so people are continually going back and forth. There's an added danger because buprenorphine binds tighter that if it's in your system it takes a lot more dope to kick the buprenorphine off the receptors, so lots of overdoses. This, I believe, is the reality.

Of course Suboxone and methadone are so much safer to use than street heroin. And doctors will help those who want to, to taper. I just don't think that describes most sub/methadone users.

I don't think the issue is a lack of safer alternatives. It's whatever is driving the person to seek out the effects produced by those drugs in the first place.

coleifer··on OxyContin billionaire has patented a drug to wean addicts from opioids
Crazy. Sub clinics are sad places. Gray-faced junkies paying $3-400/month to stay hooked. A buprenorphine script is probably $10/month. It's a racket. Capitalism at work.
coleifer··on Why Read the Classics? (1986)
I got my degree in English lit, but it's only as an adult, with the benefit of life experience, that I feel I can really appreciate so many of the books I read in college and high school. The best books seem to say something true in a way that goes beyond black and white. A truth you can only find in the experience of living.
coleifer··on Silicon Inquiry: A personal inquiry into the tech industry
Better: https://nplusonemag.com/issue-25/on-the-fringe/uncanny-valle...
coleifer··on LiteTree: SQLite with Branches
Cool project thanks for sharing your work. There's an older project using lmdb (which doesn't support branching or anything, just for storage)...is litetree's usage of lmdb comparable to what sqlightning does? How does litetree work with the write-ahead log? How do multiple concurrent connections interact? Are multiple writers allowed? Can readers and writer(s) coexist?
coleifer··on Redis is not “open core”
Sqlite is in the public domain and, like redis, has various apis for writing your own extensions. Some of those extensions are free, some are proprietary (thinking of sqlite encryption extension, although there are free alternatives).

There's nothing new about this. Postgres has apis for writing foreign data wrappers, MySQL has pluggable storage engines, etc etc.

Is antireZ worried about redis' reputation after the hn license drama? Is he just waxing philosophical? I kept waiting for the post to go somewhere.

Redis is awesome. antireZ is doing great work. Its a bummer he felt compelled in some way to write this.

coleifer··on Dynamic Django Models with Model Models
Another way of describing this is:

* Django has facilities for mapping Python classes to database tables

* Author uses metaprogramming to construct classes to match table definitions decided at runtime

* Author uses built-in schema migration tools to synchronize backend

There's nothing about this that wows me, although it does demonstrate knowledge of Django internals and Python metaprogramming. It doesn't impress me because this is the bread-and-butter of what Django does.

coleifer··on SQLite – The “server-process-edition” branch
It may be a bit out-of-date, but BerkeleyDB provides a SQLite front-end that supports page-level locking -- and thus has better TPS when multiple threads are writing. It's basically SQLite with the btree ripped out and replaced with BerkeleyDB. More information here [0].

[0] http://www.oracle.com/technetwork/database/database-technolo...

coleifer··on SQLite Release 3.25.0 adds support for window functions
For Python folks interested in using these features, you might be interested in this post [0] which describes how to compile the latest SQLite and the python sqlite3 driver. I've got a fork of the standard lib sqlite3 driver that includes support for user-defined window functions in Python as well which may interest you.

[0] http://charlesleifer.com/blog/compiling-sqlite-for-use-with-...

[1] https://github.com/coleifer/pysqlite3

coleifer··on SQLite Release 3.25.0 adds support for window functions
You can use https://github.com/coleifer/pysqlite3

It even supports user-defined window functions using the new sqlite apis.

coleifer··on How Numba and Cython speed up Python code
How's the standard library in nim? What's the 3rd party package ecosystem like? If I have questions will I be able to find a good answer on Google? How about jobs?

There's a handful of languages out there you could consider "faster python". I just use cython though.

coleifer··on Lubuntu is taking a new direction
While it's true that you can run plain-old Ubuntu on a 10-year-old machine without problems, the growth in popularity of smaller ARM processors (rpi etc) also creates demand for a lightweight linux distro. When I read the title I assumed that Lubuntu's new direction was to move towards offering better support for such devices. Guess they're going the opposite direction...too bad.
coleifer··on Best Buy Is Thriving in the Age of Amazon
The counterfeit issue seems to be getting worse, not better. It's also become harder to differentiate legitimate listings from the manufacturer versus a third-party. I bought my smart TV from Best buy simply because I don't trust Amazon anymore. I'm having a hard time thinking what I wouldn't be suspicious of on Amazon...clothes are regularly counterfeit, colognes, electronics... Maybe books?
coleifer··on Digital Exile: How I Got Banned for Life from AirBnB
The host complaining that the guest was entitled to a room they had paid for is unbelievably ironic. I guess the irony was lost on Airbnb.
coleifer··on Why no Easter Eggs? (2005)
The way I read it: we are taking your money (oh so much), we can't risk losing your trust if you happen to have no sense of humor AND we want to preserve the illusion that this is serious business.
coleifer··on MacOS Mojave removes subpixel anti-aliasing, making non-retina displays blurry
Wasn't typography Steve Jobs "big thing" he wanted to do well on the Mac?
coleifer··on Losing 100 pounds in 276 days
Congratulations buddy, I can't imagine how hard that must have been. Thanks for sharing what you experienced.
coleifer··on ActorDB – Distributed SQL database
Anybody using this in production? What particular problem were you solving with actordb?
← PreviousPage 10 of 17Next →