phillc73

20 ms·

181.
by phillc73 6y ago
> "active_users" isn't a table, it's the result of the CTE in the query Maybe we really are at cross purposes. In the duckdf example above "active_users" is a dataframe. The duckdf library applies SQL querie
182.
by phillc73 6y ago
I think we're talking at cross purposes, and I don't want to belabour the point too much, but there's no need to modify the original SQL query (I'm imagining this pulls data from a database). If the data is already in a
183.
by phillc73 6y ago
I agree that dbplyr is a nice way to query databases, if already familiar with dplyr (actually I think dtplyr is more interesting for operating on data.tables). However, I'm not sure I really understand your point about the "if&qu
184.
by phillc73 6y ago
I agree that Tidyquery and duckdf are quite new, but sqldf has been around for a long time. The first package upload to CRAN was 2007. Also, duckdf uses duckdb[1] to register a virtual in-memory table, so there's very little overhead f
185.
by phillc73 6y ago
> SQL is a perfect language for analytics. Slightly off topic, but I strongly agree with this statement and wonder why the languages used for a lot of data science work (R, Python) don't have such a strong focus on SQL. It might jus
186.
by phillc73 6y ago
I'm not sure I can agree with the "death's door" statement, but I do agree that many COVID-19 related deaths were in people with some other underlying conditions. I also find the way COVID-19 related deaths are being cou
187.
by phillc73 6y ago
Kanboard (FOSS) - https://news.ycombinator.com/item?id=22888734 Nullboard (FOSS) - https://news.ycombinator.com/item?id=26151207 Personal Kanban (FOSS) - https://news.ycombinator.com/item?id
188.
by phillc73 6y ago
I don't use Apache Arrow, so I'm in a poor position to compare it with DuckDB. My use case for DuckDB is effectively querying R dataframes with SQL. DuckDB has the functionality to register virtual tables, with data from existing
189.
by phillc73 6y ago
If you like SQLite, then DuckDB[1] is probably worth looking at. Very similar in many ways, but DuckDB is a column-oriented rather than row, so does have some performance advantages. It is quite new, so I might not go all in for mission cri
190.
by phillc73 6y ago
That's a really good point that I'd not really thought about. I'd never really considered the difference between calling just functions versus macros. Thinking about Query.jl and DataFramesMeta.jl, and I am for sure not an ex
191.
by phillc73 6y ago
Query.jl supports two different paradigms, one inspired directly by LINQ, the other by dplyr.[1] I actually prefer data.table in R, over dplyr, and Query.jl is really quite different. [1] http://www.queryverse.org/Query.jl&#
192.
by phillc73 6y ago
Have you tried Query.jl or DataFramesMeta.jl?
193.
by phillc73 6y ago
In modern British use, a pinhooker is someone who buys yearling thoroughbred horses, hoping to sell them for a profit when they're two year olds.[1] Until this article I did not know the origin of the term. [1] https://bradl
194.
by phillc73 6y ago
It's a way to write scientific reports, or other documents integrating Julia code chunks, from inside your current IDE (Juno, VSCodium etc). There's no need for an external server, like Jupyter. The code execution relies on the ID
195.
Weave.jl – Scientific Reports Using Julia(weavejl.mpastell.com)
127 points by phillc73 6y ago|17 comments
196.
by phillc73 6y ago
Astronomy, seismology, microscopy. There's an interesting query language, SciQL[1], built to support such use cases. It can be used with MonetDB.[2] [1] https://projects.cwi.nl/scilens/Resources/SciQL.html [2
197.
by phillc73 6y ago
If you're interested in Pluto.jl, I recently saw an announcement about Neptune.jl[1], which appears to remove some of the reactive nature of Pluto. It's a fork of Pluto and executes code sequentially one cell at a time instead. An
198.
by phillc73 6y ago
I'm all for finding alternatives to RStudio's dominance in the R space. No doubt they do some excellent things, but I also have a vague uneasiness at the cultishness surrounding some of their products. It sometimes feels like if y
199.
by phillc73 6y ago
The benefits of agricultural deregulation is not entirely clear cut. I quite closely followed the deregulation of the Australian dairy industry (had worked in the industry and still with friends who do) and the outcome 20 years later has no
200.
by phillc73 6y ago
I know it's pedantic, but the company is Thorlabs, not Thor Labs. Sure you've built a lab using their equipment?
201.
by phillc73 6y ago
I do wonder why I almost never see Session[1] mentioned in these conversations. Free, open source, encrypted by default, distributed, no metadata sharing, phone number not required..... I'd love to see more technical discussion about t
202.
An end-to-end encrypted messenger that minimises sensitive metadata(getsession.org)
1 points by phillc73 6y ago|0 comments
203.
by phillc73 6y ago
It'd be interesting to know how this compares with alternative solutions. I might not understand the benefit proposition correctly, and I'm not specifically into Python for data work, but I immediately thought of things like feath
204.
by phillc73 6y ago
The other day I found Boxcryptor for Teams[1] which seemed like a useful tool, if the company can be convinced to use it. At least it feels like an option for a privacy concerned organisation, which somehow ended up in the Microsoft 365 eco
205.
by phillc73 6y ago
I've been watching Colony on Netflix and became intrigued by numbers station broadcasts. Down the Internet research rabbit hole. Surprisingly, a fair few numbers stations continue to broadcast. Makes me almost want to buy a shortwave r
206.
Numbers Station(en.wikipedia.org)
3 points by phillc73 6y ago|2 comments
207.
by phillc73 6y ago
Nice find! Almost as interesting as Orwell is George Bernard Shaw making the list.
208.
by phillc73 6y ago
In Settings / Privacy and Security / Blocked Users there's a "+ Block User" option. Clicking this brings up a list of all chats and people who have messaged your directly. Selecting a name blocks a user. Maybe even
209.
by phillc73 6y ago
The Morning Star newspaper I referred to was founded in 1930 as the Daily Worker, and renamed to the Morning Star in 1966.[1] [1] https://en.wikipedia.org/wiki/Morning_Star_(British_newspape...
210.
by phillc73 6y ago
I was completely surprised by this story and website. For me, the Morning Star is a British socialist newspaper[1] and I thought the story would be about debunking the myth of the outlaw Robin Hood. Quite an irony that this Morning Star web

More ›