chrisjc

7 ms·

31.
by chrisjc 3y ago
I was about to comment in agreement while also mentioning about having a means to put the hardware up there. But then I realized that there's absolutely no reason why they couldn't just pay SpaceX to put them up there (until Blue
32.
by chrisjc 3y ago
I'm also pretty excited about Arrow Database Connectivity (ADBC) development. https://arrow.apache.org/docs/format/ADBC.html And nanoarrow but it seems like the adoption has been pretty a little slow. Perhaps
33.
by chrisjc 3y ago
I haven't taken a close enough look at it yet, but duckdb supports Sqlite databases, so in theory yes. However, using Sqlite requires a duckdb extension and i'm not sure if works for wasm, and if so enabled this project in particu
34.
by chrisjc 3y ago
I just like to thank you (again) for how much you've made a lot of what is required to get duckdb up and started (esp on AWS) much easier. Interesting to watch the similarities (duckdb wasm) and differences (python vs js) between your
35.
by chrisjc 3y ago
I'm not too familiar with FUSE, but I would imagine that you are doing something similar to registering a custom filesystem on duckdb, then intercepting certain filesystem activities to trigger all the magic described in the blog? Also
36.
by chrisjc 3y ago
Not sure if I entire understand what you're saying. Do you mean to suggest this would work well for digital video broadcasting (or equivalent to it)? If so, this is what I have been theorizing as a potential future step for Starlink. O
37.
by chrisjc 3y ago
Others have pointed out why boosters don't count. But what about Dragon?
38.
by chrisjc 3y ago
Yup. Your code in github explains what you're suggesting better. My bad.
39.
by chrisjc 3y ago
If I understand your code correctly, you are bypassing DBAPI's binding functionality and opening yourself up for SQL injection. QParams = sqlbind.Dialect.some_dialect @QParams def make_my_query(value1: str, value2: int):
40.
by chrisjc 3y ago
It's a little difficult to parse through the README, but I believe placeholders and placeholder structure is being rendered in the SQL, not placeholder values. ps = f'SELECT * FROM table WHERE field1 = {q/value1} AND fi
41.
by chrisjc 3y ago
Isn't low-level hardware really at the heart of a lot of this? Hasn't a lot of the criticism of Cuda been that it's incredibly difficult for others to implement on other hardware bc of the low-level interactions and Nvidia&#x
42.
by chrisjc 3y ago
> Touch, feel its texture, feel its weight, get tactile feedback, organising physical objects in a spatial world. This is simply the natural behaviour of the human animal. I would add that there was also joy to be had resulting from the
43.
by chrisjc 3y ago
The Point-of-sale tax credit (effectively what you are describing) for qualifying new EVs is now live in the US too. Whether you actually qualify or not is matter that is taken up between you and the IRS. I believe that if at the end of the
44.
by chrisjc 3y ago
It's not always clear which pushdowns are available in DuckDB. For instance, while x = y has been available for a while, x in (y, z, ...) hasn't. The DuckDB team seems very eager and motivated to get all the pushdown functionality
45.
by chrisjc 3y ago
Came here with similar questions and Cmd-F "DuckDB". See the comment about "data loaders". Seems like a "data loader" would provide most of what you're asking about. I'm also thinking that a "dat
46.
by chrisjc 3y ago
Can you link to the "data loader" API or perhaps even a "data loader" example implementation for something similar to malloy, duckdb, or any other DB/SQL data source/provider? Would love to see it, thanks in ad
47.
by chrisjc 3y ago
I feel the same way and struggle with lack of physical controls on my phone (eg iphone flashlight!!!). I couldn't imagine operating a car this way. That said, just want to point out a couple of things that I don't think are true.
48.
by chrisjc 3y ago
I've been scanning through the comments looking for the opportunity to ask, while not seeming critical... why start with Delta Lake instead of Iceberg? I imagine it might have had something to do with timing and the state of Iceberg at
49.
by chrisjc 3y ago
Missed a step 1. Be co-founder and former CEO 2. Remain calm 3. Tweet at your 66k followers 4. Briefly wait while the dozens of those that work at GitHub trip over each other getting your account reactivated
50.
by chrisjc 3y ago
Adding to this. https://duckdb.org/2024/01/26/multi-database-support-in-duck... Unsure what the parent means by "ingest" SQLite tables (although i believe you can use COPY with sqlite tables in Duck
51.
by chrisjc 3y ago
Somewhat similar, see https://substrait.io/ So for example using DuckDB with the Substrait extension, if you create a table create table t(a int); and then query it as in the article, you can see something similar
52.
by chrisjc 3y ago
Now that you mention it, I guess I've experienced *similar* issues (more to do with joins, unions, materializations, windows, etc) even when there is a query planner. Even though the query planner has an optimizer, the plan produced is
53.
by chrisjc 3y ago
I'm interested to understand why you think it should differ between OLAP and OLTP? Are you suggesting that columns closer to the top matters for OLAP bc OLAP is columnar? Ultimately, a query planner is going to figure out what happens
54.
by chrisjc 3y ago
But interestingly DuckDB doesn't support `SELECT 'FOO' AS BAR FROM DUAL;` or `SELECT 'FOO' AS BAR FROM 1;`. Which I guess makes sense if it has an implicit `SELECT *`. What would the implicit projection of `FROM DUA
55.
by chrisjc 3y ago
Sounds like a job for DuckDB. DuckDB is to Snowflake/Bigquery (OLAP/analytics) what sqlite is to mysql/postgres (OLTP). https://sql.quacking.cloud/ https://duckdb.org/docs/archive/0.
56.
by chrisjc 3y ago
The points about antitrust and similar situations like Netflix/Amazon have already been made by others... So it's interesting to note that other Satellite Internet companies/startups/etc are already using SpaceX to put t
57.
by chrisjc 3y ago
> If the Apple II was the 70s and the Macintosh was the 80s and NeXTSTEP was the 90s and the iPhone was the 2000s, name the thing of this caliber they did in the 2010s. Apple Silicon?
58.
by chrisjc 3y ago
> but probably not the best thing for modern society do you mean for leaders and officials in modern society, or anyone? Either way, I'm genuinely curious why you generally think this?
59.
by chrisjc 3y ago
Absolutely! I remember playing Quake 3 and whatnot back in the day. As I became immersed in the game, keyboard/mouse/1024 would eventually disappear (figuratively). Strangely enough, I feel like there is more friction for me to pl
60.
by chrisjc 3y ago
> The way it was overlooked by me is because a ‘bin’ is something you clear regularly, but deleted records will likely persist forever. Clear regularly, but usually also has the option to undo. The article sort of suggests something simi

More ›