chrisjc

13 ms·

91.
by chrisjc 3y ago
TruffleRuby runs Rails and is compatible with many gems, including C extensions. TruffleRuby is not 100% compatible with MRI 3.2 yet. Please report any compatibility issues you might find. TruffleRuby passes around 97% of ruby/s
92.
by chrisjc 3y ago
Which Python Client? The one using ADBC/nanoarrow? If not, the issue might be related to converting columnar data to row-based. https://www.youtube.com/watch?v=9FOp160CZYE
93.
by chrisjc 3y ago
> One thing I'll respectfully disagree with — "SQL is highly statically analyzable by nature" Are you suggesting that PRQL is capable of this? Or at least easier to do in PRQL?
94.
by chrisjc 3y ago
Not a criticism, more of an observation. The point of being able to write "FROM" before "SELECT" has become moot to me since many DBs support that SQL "convention" already. The newline/indentation is somet
95.
by chrisjc 3y ago
Yeah... very painful!
96.
by chrisjc 3y ago
Only potential problem (at least when I checked on the state of the beta) is that the person you share it with has to be on iOS 17 too. This was the reason I didn't bother with the beta (although it was the feature I needed asap) since
97.
by chrisjc 3y ago
We'll, I guess were just going to have to wait and see if its fixed. But seriously! Typing is sooo bad on iOS, that it has almost made me move back to Android.
98.
by chrisjc 3y ago
Isn't the "physical plan" the part that gets the "set of tuples", not the "logical plan"? And isn't that matter of how that gets done more a concern of which physical plan the query optimizer picks, a
99.
by chrisjc 3y ago
That's the first "dataframe" listing in the book. The first listing is the SQL examples. Both SQL and dataframes have to be prepared for the query engine. You can read the whole book without ever needing to take into consider
100.
by chrisjc 3y ago
> One thing I couldn't wrap my head around, why there is no standalone version? Standalone version of what? DuckDB? If you mean DuckDB, there is: https://duckdb.org/docs/archive/0.8.1/installation&#x2F
101.
by chrisjc 3y ago
> I keep explaining all we have to do is build a data mart built using SQL Server, and use our ETL tools to keep it populated with the data they need to analyze. I can relate and have experienced this. The result was that they would end
102.
by chrisjc 3y ago
I'm sure DuckDB was used to transform/prepare the data from the ERP extract format to an MSSQL ingestion format. There are plenty of arguments and reasons why you would use DuckDB to do this esp if you're preparing the data f
103.
by chrisjc 3y ago
Nice! Might this pave the way for an ADBC_scanner extension since I imagine the adbc and nanoarrow dependencies will be built in!? Similar to postgres_scanner, sqlite_scanner, odbc_scanner https://github.com/duckdblabs/
104.
by chrisjc 3y ago
Very out of touch with Postgres, but is there a native column oriented table type option in Postgres so that you choose either row-based or columnar in the CREATE TABLE DDL?
105.
by chrisjc 3y ago
Actually, Snowflake is the reason I ask :)
106.
by chrisjc 3y ago
Can you do ADBC next? ;) https://arrow.apache.org/docs/format/ADBC.html
107.
by chrisjc 3y ago
But isn't this the point of being able to use both duckdb databases and sqlite databases from the duckdb runtime? You can mix and match read/write use-cases within the same duckdb db runtime? Perform OLTP actions against sqlite db
108.
by chrisjc 3y ago
> Snowflake stores data in S3 in Snowflake's various AWS accounts. Egress fees are necessary when performing anything outside of Snowflake. Egress fees are only if you are unloading into a different region/cloud. If your data i
109.
by chrisjc 3y ago
Agreed... Their SQL is awesome and seemingly only getting better. My favorite is window aliases (I'm sure it's found in other SQL engines too). It's not only cleaner and less likely to accidentally introduce a discrepancy, bu
110.
by chrisjc 3y ago
IceDB sounds like an interesting project. What are your thoughts on Apache Iceberg? Seems like a similar idea, and gaining a lot of traction in the data-eng world.
111.
by chrisjc 3y ago
Very interesting. Would you mind mentioning which external table format you were using? Iceberg by any chance? I wonder if there wasn't a middle-ground that could still utilize DuckDB or similar. You still rely on BQ to deliver the sub
112.
by chrisjc 3y ago
Would you mind explaining your issues in a little more detail? > being passed user-defined SQL What does this mean exactly? Customers were writing their own SQL on their own machines? Maybe expensive operations such as: `SELECT ROW_NUMBE
113.
by chrisjc 3y ago
> Intellij What? how?
114.
by chrisjc 3y ago
I'm not convinced the boat isn't coming, or hasn't already arrived back to port. Lots of great talent in Mexico, and I'm not referring to call center jobs. I'm talking about first class engineers.
115.
by chrisjc 3y ago
From what I see, and what I'm experiencing, it is and has been taking off. For the last few years I've been interacting with members from other teams in Latin America and it's been nothing short of a pleasure. Now in the proc
116.
by chrisjc 3y ago
While I don't disagree with the essence of what you're concerned about, I imagine that every new step/functionality in the browser evolution introduces new minutiae that can be used in fingerprinting. Also, once/if the W
117.
by chrisjc 3y ago
This is the discussion I hoped to find when clicking on the comments. > Fairly soon, WebGPU will be an alternative... So while the blog focused on the graphical utility of WebGPU, the underlying implementation of WebGPU is currently abou
118.
by chrisjc 3y ago
Interesting! What are you using SQLite for? If it's analytics, perhaps DuckDB WASM might be an option?
119.
by chrisjc 3y ago
Curious why you're asking this question when it seems to have little to do with Datomic going "free"? Did you mean Datomic WASM on the horizon? Or am I missing some other connection between SQLite and Datomic?
120.
by chrisjc 3y ago
What the launch did do to the launch area is going to be an interesting story to follow.

More ›