TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Graph-Based Ceramics

40 点作者 nezaj11 个月前

5 条评论

areichert10 个月前
Author here!<p>Surprised to see this on the front page again (hello fellow pottery enthusiasts?), but figured this could be a good chance to address some of the comments from the recent discussion [0] since I missed it last time :P<p>The most common feedback seemed to be, &quot;this is dumb, just use SQLite&quot;, which is definitely valid.<p>This was actually how I initially started building the app (using SQLite), and it worked pretty well. There were a couple reasons I abandoned this approach though: one, whenever I had to uninstall and reinstall the app, the data would get wiped; two, I still had to deal with migrations and other annoying boilerplate; and three, I wanted to be able to share my results with my friends in a read-only web view.<p>(That being said, I&#x27;m also curious to explore how tools like ElectricSQL [1], PowerSync [2], TinyBase [3], etc. play with SQlite to handle some of these issues. At a glance, it just seemed like these would require more time to setup compared to InstantDB [4].)<p>Another similar comment that popped up a few times was the idea that if I&#x27;m trying to model _relational_ data, it would be ridiculous to use anything other than a _relational_ database.<p>I think that&#x27;s fair, but I also think it&#x27;s fair to say a graph database is also &quot;relational&quot; in some sense, or at least &quot;relationship-centric&quot; [5] :)<p>Either way, I had a lot of fun with this. And I was definitely optimizing more for speed&#x2F;scrappiness than for doing it The Right Way, so if anyone has any thoughts on how to build stuff faster, I&#x27;d love to hear it!<p>[0] <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=40860116">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=40860116</a><p>[1] <a href="https:&#x2F;&#x2F;electric-sql.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;electric-sql.com&#x2F;</a><p>[2] <a href="https:&#x2F;&#x2F;www.powersync.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.powersync.com&#x2F;</a><p>[3] <a href="https:&#x2F;&#x2F;tinybase.org&#x2F;" rel="nofollow">https:&#x2F;&#x2F;tinybase.org&#x2F;</a><p>[4] <a href="https:&#x2F;&#x2F;www.instantdb.com&#x2F;">https:&#x2F;&#x2F;www.instantdb.com&#x2F;</a><p>[5] <a href="https:&#x2F;&#x2F;aws.amazon.com&#x2F;compare&#x2F;the-difference-between-graph-and-relational-database&#x2F;" rel="nofollow">https:&#x2F;&#x2F;aws.amazon.com&#x2F;compare&#x2F;the-difference-between-graph-...</a>
评论 #40924203 未加载
评论 #40924542 未加载
评论 #40928959 未加载
raymondgh10 个月前
This is awesome. About five years ago I wanted to solve the same problem of tracking my pots and glazes. I also noticed the many:many relationship very quickly and deliberated on the schema. Neo4j looked really cool but I think I ended up going with join tables (ie pots, glazes, pot_glaze) in Postgres. I think I didn’t get nearly as far as you did in a weekend though!<p>Lately I hack in firebase and have been interested in trying supabase. I’ll have to add instantdb to my list.<p>You should productionize this! Get glaze recipes in there too!
评论 #40922633 未加载
dang10 个月前
Discussed recently, but maybe didn&#x27;t get enough attention?<p><i>Graph-Based Ceramics</i> - <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=40860116">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=40860116</a> - July 2024 (17 comments)
potter202410 个月前
there is actual science behind this, check a glaze calculator like insight <a href="https:&#x2F;&#x2F;insight-live.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;insight-live.com&#x2F;</a> and component info like <a href="https:&#x2F;&#x2F;digitalfire.com" rel="nofollow">https:&#x2F;&#x2F;digitalfire.com</a>
评论 #40932750 未加载
throwawayyyyhhh10 个月前
If you&#x27;re trying a lot of different options you may want to check out something called Design of Experiments. [0]<p>0. <a href="https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Design_of_experiments" rel="nofollow">https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Design_of_experiments</a>
评论 #40922643 未加载