smiths1999

13 ms·

1.
by smiths1999 21d ago
Answered elsewhere but the tl;dr is lock the db file. The design is multiple readers, single writer.
2.
by smiths1999 21d ago
Why not use something else? I wanted to build something from scratch. What you've built with ArcadeDB is definitely impressive, but much larger scale that what I was trying to accomplish with this. Like the repo says, think sqlite but
3.
by smiths1999 22d ago
Not comparable. Similar to Neo4j vs LatticeDB. Lattice's goals are simplicity, single file, super easy to start using. Surreal supports embedded mode, but my understanding is it is not a single file. Surreal supports a huge number of d
4.
by smiths1999 22d ago
Just added file locking to avoid concurrent writers across processes in the latest release.
5.
by smiths1999 22d ago
Thanks - appreciate the feedback! I wanted the README to be something you could quickly glance at, get a sense of the project and whether it's what you are looking for, and be done with it.
6.
by smiths1999 22d ago
Thanks for sharing this. The lattice numbers are pretty close but my sqlite numbers are way off. I got a new computer since then so will remeasure.
7.
by smiths1999 22d ago
I started thinking more deeply about how I would actually do this today and it won't be as straight forward as I initially thought. Will keep it on the radar and see if I can figure out a clean way to implement. Great suggestions!
8.
by smiths1999 22d ago
I am in the final stages of adding this based on your comment. Just wrapping up doc updates and will push a new release with hot copy functionality tonight!
9.
by smiths1999 22d ago
Within the same process it's enforced at the db level. After reviewing the code more I see we don't have a mechanism in place to manage safety across processes. Will add a file lock mechanism tonight. Great call out! In general th
10.
by smiths1999 22d ago
The permissions question is interesting. I think the answer depends on context. One approach would be to create some edge types `hasAccessTo` and `accessibleBy` that connect a user to a node. Then I'd create an edge type `childOf`. The
11.
by smiths1999 22d ago
very cool site!
12.
by smiths1999 22d ago
Great question! Two reasons. One, I wanted to build something on my own from the ground up rather than contribute to an already established large project. For me, it's a better way to learn. Hopefully people find it cool and want to us
13.
by smiths1999 23d ago
Yes! This is something I've been thinking about quite a bit the past few weeks. We are going in this direction at work and I think graph storage is a natural way to think about this.
14.
by smiths1999 23d ago
I used claude extensively (as well as codex, I finding myself switching between the two every few months). How I used claude varied by the stage. I spent a lot of time initially going back and forth with claude on the idea, figuring out wha
15.
by smiths1999 23d ago
Thank you!
16.
by smiths1999 23d ago
duckpgq is great. I'd say the tl;dr is duckpgq if you have tables you want to traverse like a graph sometimes, latticedb when graph traversal is the primary mechanism of querying. One of the motivating use cases for me was experimentin
17.
by smiths1999 23d ago
I like the aesthetics of this page. Very clean and visually appealing
18.
by smiths1999 23d ago
I did some perf benchmarking with 1M nodes but I'm mostly using it at smaller scales for another project exploring agentic memory. Most interesting part is a tough one. From a learning perspective the beginning was incredibly interesti
19.
Show HN: LatticeDB – Like SQLite but for graph databases(github.com)
190 points by smiths1999 23d ago|54 comments
20.
by smiths1999 2mo ago
If the company does any kind of work with the US Government it's far easier to just say no to Chinese-origin models rather than deal with all the overhead on the government contracts. Since just about every major tech company has US co
21.
by smiths1999 3y ago
I apologize if this is a stupid question but why wouldn't everyone be investing in India with these returns being standard? In the US we would assume a conservative rate of 7%
22.
by smiths1999 3y ago
I don't follow. Aren't employee salaries a deductible expense? The above makes me think more along the lines of no longer being able to deduct GPU costs incurred from deep learning research.
23.
by smiths1999 5y ago
I would suggest coming up with a set plan for meals and eat the same thing every day for two out of three meals. For me, during the work week, I have a bowl of oatmeal (steel cut oats, nuts, and a banana) for breakfast, a salad with lots of
24.
by smiths1999 5y ago
This has been my experience as well. The first time I tried it I thought I was going to be miserable all day and have no energy. It ended being totally fine. I have this dull emptiness in my stomach but nothing that affects me in any way. A
25.
by smiths1999 5y ago
Zettlekasten is more about making connections between ideas and keeping your ideas organized. The primary use is for generating ideas and writing, not for information retrieval. The flow is: 1. Read something and take notes 2. Review and di
26.
by smiths1999 5y ago
AWS going down means I've lost it or temporarily lost access to it? Those are two very different scenarios. Of course S3 could lose data - a quick Google search shows it has happened to at least one account. My guess is it is rare enou
27.
by smiths1999 5y ago
I suppose the caveat is you have to have customers to lose them :) We don't know what the data is or the size of the company.
28.
by smiths1999 5y ago
Sure you can. As the experienced engineer in that setting it is a great opportunity to teach the less experienced engineers. For example, "I have seen data loss on S3 at my last job. If X, Y, or Z happen then we will lose data. Is this
29.
by smiths1999 5y ago
Yes - the point of that line was to be ridiculous. Age has nothing to do with it. Anyone at any age can have good ideas and bad ideas. There are some really incredibly _older_ and highly experienced engineers out there. But there are others
30.
by smiths1999 5y ago
I'm not sure how you got "backups are for old people" from my post. My point is that there are two sides to this. Perhaps the data being stored on S3 data _was_ backup data and this engineer was proposing replicating the back

More ›