vaughan

18 ms·

151.
by vaughan 5y ago
Absurd is really cool. I've always thought it would be great to have an SQL db implemented in native JS though. With the database running in the same process as your app, you could store native JS Objects of your table rows in the cach
152.
by vaughan 5y ago
"code/framework overhead" is fine as long as its hidden in a library. Too many people re-implement a data layer client-side that is always a poor mapping to the server data model. My frontend should act as if its running off
153.
by vaughan 5y ago
> (I'm not sure if a file should be allowed to belong to multiple tags within the same hierarchy; my gut says no.) Gmail is a good example. Has very flexible tagging schema. Every tag exists in a hierarchy. Emails can have multiple
154.
by vaughan 5y ago
My big realization was that the relational model is a constraint on your data so that relational algebra can optimize your queries for perf. But these constraints cause a whole range of issues, which always result in a poorly modeled domain
155.
by vaughan 5y ago
SQL is simply converted into a logical relation algebra tree. So anything that can do that could be used. It's a shame that PSQL doesn't provide an API for this, then all the quirks of SQL could be fixed. However, then we would pr
156.
by vaughan 5y ago
Try a 3-way M-M join. Or recursive CTE's for hierarchical data. It always looks clean with simple examples. Data these days is much more nested and inter-related.
157.
by vaughan 5y ago
So you are talking about something like SQLite-as-the-API? I was a big fan of this idea for a while. Difficulties in streaming query updates from SQL dbs and difficulties in working with deeply nested, hierarchical data made me shy away fro
158.
by vaughan 5y ago
Depends what you mean by developer, but there a heaps of ways to accidentally write code that doesn't use an index, and then you need to understand db internals and how indexing works, and so you are on your way to being a SQL dev. A n
159.
by vaughan 5y ago
These contrived examples seem appealing at first, but when you start having deeply relational, nested data, with M-M joins, the relational model is much less appealing. SQL is just one popular declarative approach that people are familiar w
160.
by vaughan 5y ago
I've always felt a more modular SQL database system is needed. SQL dbs are too black box. You can't interact with the query planner. NoSQL essentially is doing just this. SQL dbs have great underlying layers such as storage, cachi
161.
by vaughan 5y ago
What you need is a versioned mapping layer from the scraped data into your own schema. The problem is when you need to update your schema to support data/relations not available in your own schema. The problem with SQL is that schemas
162.
by vaughan 5y ago
I've come to realize the relational model is not a great fit for most data. It constrains your data model for the purpose of representing your queries in relational calculus, which allows a corresponding relational algebra to operate o
163.
by vaughan 5y ago
Web apps are so over-complicated because of piecemeal client side data stores and the need to sync with the latest fashion in api protocol. Imagine how simple apps would be if your data model and query interface was exactly the same on the
164.
by vaughan 5y ago
I think most dbs, paas, frameworks skip this use case. For a snappy data-centric app, you pretty much need your entire app logic to run client-side. Everyone always ends up with this terrible denormalized client-side cache with duplicated S
165.
by vaughan 5y ago
I think coding and no-coding should eventually converge. Software development has become far too complex without the right sensible abstractions keeping things under control. Every developer would probably want an Airtable control to drop i
166.
Is the future of web about the client or the server?
2 points by vaughan 5y ago|1 comments
167.
by vaughan 5y ago
We had the cheapest 2 slice. Now it started occasionally tripping a fuse. I use it everyday and feel I underinvested greatly. I would like a 4 slice but a good brand like Breville. I want speed, toasting accuracy, easy to remove slices, eas
168.
by vaughan 5y ago
MS owns GitHub which maintains Electron. Core maintainers are MS employees.
169.
by vaughan 5y ago
I'm stuck on 50mbps up.
170.
by vaughan 5y ago
Incremental backup + file watching = very fast. See: https://9to5mac.com/2021/05/19/carbon-copy-cloner-for-mac-ov... .
171.
by vaughan 5y ago
I forgot it didn't work the last time, and I needed an offsite backup solution. I was optimistic that I could configure the right excludes so it would work, but the sys pref change made this impossible. It takes a few weeks to upload e
172.
by vaughan 5y ago
I have paid for Backblaze for 4 years, after signing up for two 2 year subscriptions a few years apart. I have never got it to backup my files ever. Their settings dialog integrates with macOS preferences and freezes while it scans for file
173.
by vaughan 5y ago
Competition is the wrong word. Microsoft owns both projects. Surely there will be a rebrand and resource shift to WebView in the next couple years.
174.
by vaughan 5y ago
> But what happens when you need My experience is that a lot of these features are more easily implemented than the time taken to handle the edge cases of using existing libraries, getting them to work with your UI framework (React/
175.
by vaughan 5y ago
I have never used a data grid control that didn't end up with me having to dig deep into the code to add something custom that I needed, and just hit brick wall after brick wall. Especially React-based ones. We don't need big libr
176.
by vaughan 5y ago
The goal should be to do whatever makes the code read nicely, instead of forcing a single pattern which won’t work well in very case. Destructuring where two funcs in the same scope return the same named object key will make your code harde
177.
by vaughan 5y ago
They are not ideal in webstorm. Sometimes they make lines run off the page, and they are a bit jarring the way they appear and disappear.
178.
by vaughan 5y ago
I think local CPU is underutilized in these cloudy days. For many SaaS, the size of all your tenant data minus media is quite small. Most cloud apps have terrible experience with large tables, searching, and general perf. We trade this away
179.
by vaughan 5y ago
Quite interesting read about how timescaledb turns a row store (psql) into a column store.
180.
by vaughan 5y ago
Frameworks.

More ›