HNHacker News
TopNewBestAskShowJobs

coleifer

2,485 karma · joined November 3, 2009

submissionscomments
coleifer··on Xapiand: A fast, simple, modern search and storage engine
Somewhat unrelated but I've written a restful search server that's powered by Sqlite's full-text search. Extremely lightweight python (flask) app. Nice for blogs or small projects, if I say so myself!

https://github.com/coleifer/scout

coleifer··on Notion – All-in-one workspace for notes, tasks, wikis, and databases
Looks nice, but I am uneasy putting this kind of information into an opaque platform. Google, Salesforce, a self-hosted wiki...not going anywhere plus options to export and move.

If it were a desktop app with a local sqlite DB then, yes, definitely (for single user). If I could run a network security and host it on my company intranet, absolutely.

coleifer··on Kyoto Tycoon in 2019
The purpose of the benchmark was to see the relative performance of the two databases.
coleifer··on Matz: We are mere mortals
I had a similar thing happen. The CTO of a company was using a library I wrote, and he ran into things he wanted to change. When I disagreed, I was accused of sabotaging my own library, by refusing to fix it's obviously broken aspects. Guy went on a smear campaign on hn, Reddit, Twitter, Wikipedia. Literally made me miserable for weeks.

I wrote about it, more here if you're curious:

http://charlesleifer.com/blog/your-idea-sucks/

coleifer··on Sobriety startups shaking up the 12-step model
> You drink too much for a reason

I don't think that's right. More than anywhere else, it seems like on HN there's an idea of the infallibility of human rationality. Would anyone in their right mind a) shoot dirty dope filtered through a cigarette butt, b) gamble themselves into debt with the mafia, c) overeat to the point they can't leave the house, d) play videogames compulsively for days on end, etc?

coleifer··on Sobriety startups shaking up the 12-step model
> I find the program a bit cultish

I have shared in meetings that I sometimes think AA/NA is a cult. Everyone understood. And over time I've come to see the importance of the word "Anonymous", which is found in the name (obviously) but also in the traditions, and means exactly this: that everyone is equal within the group. There is no "great leader", nobody that is "right", nobody that is "wrong". It is about sharing one's experience -- the things one has done, the actions one has taken -- which speak for themselves.

> and don't agree that telling people they are helpless is the right way to help them

The actual word is "powerless", not "helpless". And this powerlessness describes:

- the addict's inability to stop despite earnest and sincere desire.

- the inability, once clean for a short time, to keep from returning to drug use

Before I started attending 12-step, I had read the Bible, Marcus Aurelius, Tao Te Ching, various self-help books, The Power of Now, How to Win Friends and Influence People, and on and on and on. I had within me all the beliefs and understanding needed to live in a good way, in accordance with my principles. In short, to live with dignity. And yet I could not live according to my own principles. This wasn't just about drug use...it was about being patient, kind, tolerant, loving, helpful. I think that's the root of the powerlessness talked about in AA/NA. What I've found is that, with the belief in a higher power, I'm able to go to bed with a sense of dignity most days.

coleifer··on Sobriety startups shaking up the 12-step model
My own sense is that the religions of the world are mostly in agreement about the following things:

* renunciation of self

* acceptance of the world / reality, including suffering

* love of mankind

* love of the gift of life

Religion as an institution, however, is something different than the "message" contained within the sacred texts or traditions of religions (lower-case r).

Some religion attracts fanatics, those who believe "We are right and everyone else is wrong." Within that statement there is a marked absence of acceptance, love of mankind, love of life.

There is also spiritual pride, which is more subtle. In Christ's parable of the pharisee and the publican, we see the publican, who prays in all humility for God's mercy, and the pharisee, who thanks God that he is better than the publican. And many Christians reading that parable will think, "and thank God I'm not like the pharisee"!

coleifer··on Show HN: RedixDB – a fast persistent key-value store with the Redis protocol
Badger is an lsm-tree storage engine which makes some unusual tradeoffs. Good background info here:

https://blog.dgraph.io/post/badger/

coleifer··on Dostoyevsky's “Dream of a Ridiculous Man” (2014)
> I saw and know that men could be beautiful and happy, without losing the capacity to live upon the earth.

This struck me as the revelation that changed the protagonist's perspective. And Dostoyevsky presents this using the irrational, symbolic language of dreams: a vision of human dignity. He concludes by quoting Christ's commandment... showing that this isn't new knowledge. It's been known for a very long time, but one must experience suffering and a spiritual death before the full significance of the commandment can be understood.

Kierkegaard's book on Christian love provides an in-depth (and sometimes tedious) discussion of the necessity of love of ones neighbor. Recommend checking it out if you're curious to read why one could come to view such love as necessary for life.

coleifer··on Dostoyevsky's “Dream of a Ridiculous Man” (2014)
To add a conflicting voice, my own opinion is that Constance Garnett's translation of The Brothers Karamazov is Dostoyevsky's best work for English readers.
coleifer··on Addicted to vaped nicotine, teenagers have no clear path to quitting
What a conceited, naive thing to say. Try developing some compassion by talking to people whose experience directly contradicts this viewpoint.
coleifer··on Remote code execution vulnerability in SQLite
Not sure why this is being downvoted, but you're correct. Now, a networked application that exposes some level of access to sqlite? That's another story. The question I think we all are asking is just how much "leg" does sqlite have to show to be vulnerable?
coleifer··on Remote code execution vulnerability in SQLite
My guess, for what it's worth, is that chromium is vulnerable because it exposes sqlite to web applications, which can then execute queries in such a way as to achieve code execution.

I highly doubt this would affect, say, a blog running with a sqlite database. From the alarmist nature of this post, though, it's unclear.

I see chromium, in their patch, switched to using new flags when opening the DB. There are also some sqlite changes that seem to prevent meddling with virtual table shadow tables (eg inverted index for the fts3 extension).

The question I think everyone is asking is how much sqlite needs to be exposed by an application in order to be vulnerable?

Just my thoughts. Eager to learn more.

coleifer··on Compiz: Ubuntu Desktop's little known best friend
Wobbly windows. Tiling. Emerald window decorations. Rotate cube. Endless possibilities.
coleifer··on How Premium Mediocre Conquered Fashion
Some people are literally ignorant of luxury brands. My bougie sisters-in-law are locked in a competition to outdo one another with Kate spade bags, Michael Kors watches, etc., and have no idea that these aren't the height of luxury. Here in Topeka, they are (where 100k gets you a nice 3br home).

Me? I'll stick to my brand name athleisure thank you very much.

coleifer··on On Overcoming Pain
When your decision of where you live is based on availability of drugs, I think there might be a serious problem lurking, which you may not even be consciously aware of. Good luck nonetheless.
coleifer··on Ask HN: Which abandoned proprietary software would you resurrect?
What I miss about VB was the ease with which I could make desktop applications.
coleifer··on Ask HN: Which abandoned proprietary software would you resurrect?
Old-school visual basic, but maybe powered by python or another modern scripting language.
coleifer··on Whats thw crazyest thing ur goats have eaten? (2012)
I don't have a goat story but my dog Scout (RIP buddy) ate at various times: several decorative hand soaps, an entire loaf of bread, and once he got into a grease trap and drank a ton of grease. Thought he was gonna die after the grease, his eyes were all red for a few days and he was super sick, but he lived through it to have many more adventures.

http://media.charlesleifer.com/blog/photos/p1473037171.1.JPG

coleifer··on Molten – A minimal framework for building HTTP APIs with Python 3.6+
How's the community? Will it be maintained and improved over time? How quickly are issues resolved? Is it easy to get answers on stackoverflow? How's the plugin ecosystem? Are the docs clear and thorough?

I'm more interested in these types of meta-features if I'm planning to make a potentially multi-year bet on a framework.

coleifer··on Pipenv: promises a lot, delivers very little
`pip freeze > requirements.txt`
coleifer··on Pipenv: promises a lot, delivers very little
The problem, in my view, is not that pipenv is buggy or flawed or changes too rapidly. The problem is that it was hyped-up with overblown promises and marketing and sycophantic testimonials. The author of the project describes this himself in his "letter to r/python":

> ...my fame, while certainly categorized under “cult of personality” is not necessarily accidental. It’s called marketing. I worked very hard at becoming well known within the Python community, and toiled away at it for years.

I see this as the real issue, which led to premature adoption of a tool that wasn't stable, and the subsequent backlash.

Also, I have been using virtualenv for years and if I want to freeze my dependencies, running `pip freeze > requirements.txt` is sufficient for me.

coleifer··on At 22 years old, Postgres might just be the most advanced database yet
> some of the more complex SQL syntax that Postgres supports are missing, but more importantly, it can only ever do one write or read to the database predictably

I don't know...it's recently added upsert compatible with Postgres syntax as well as support for window functions.

Additionally, sqlite has a sophisticated json extension.

> it can only ever do one write or read to the database predictably

WAL mode addresses this, allowing an arbitrary number of readers with a writer.

For concurrent applications just use a dedicated write thread and enqueue writes...your example is contrived. Connection management, transaction scope management, etc, can all work in your favor. Writes occur in a few milliseconds, meaning you only need to hold the exclusive lock very briefly in most situations.

More information here: http://charlesleifer.com/blog/going-fast-with-sqlite-and-pyt...

coleifer··on Photons, Quasars and the Possibility of Free Will
The big bang/creation
coleifer··on Ask HN: What are your “brain hacks” that help you manage everyday situations?
Meditation and prayer. Meditation on compassion has been the most transformative.
coleifer··on New Parents Complain Amazon Baby-Registry Ads Are Deceptive
But everyone makes fun of the püpli kids!

https://youtu.be/krwyCx-ko_s

coleifer··on Dark web dealers voluntarily ban deadly fentanyl
Fentanyl is a shitty high, doesn't last long compared to heroin, and a tiny bit separated a high and death.
coleifer··on If it's not fun anymore, you get nothing from maintaining a popular package
Then I'd be doing exactly what he did, just dressed up a little in a blog instead of twitter.
coleifer··on If it's not fun anymore, you get nothing from maintaining a popular package
I experienced a twist on this. A guy who had very different aesthetic taste wanted me to merge some patches. He got real entitled about it, eventually I banned him. THEN he did the "appeal to Twitter" and made malicious edits to the project page on wikipedia. He made a huge stink and wasted hours of both of our time. It was unreal! I wish I was joking.

I wrote about it, discussing my motivations for open source:

http://charlesleifer.com/blog/your-idea-sucks/

coleifer··on Dealing with past trauma may be the key to breaking addiction
Doesn't sound like you broke it successfully. Hit me up if you want to talk, I've been there.
← PreviousPage 8 of 17Next →