mytherin

20 ms·

121.
by mytherin 6y ago
What is the fundamental difference between pip and npm here? `pip install` will run whatever is in the `setup.py` of the package (and recursively do the same with any dependencies). That is essentially arbitrary code execution, no? This fee
122.
by mytherin 6y ago
The system is not set up for this. You cannot play copyrighted music in a stream or YouTube video without jumping through hundreds of hoops with licensing. Especially if you are listening to a variety of songs (e.g. Spotify or a radio) this
123.
by mytherin 6y ago
Fire suppression systems fail, cars get recalled or malfunction, people get food poisoning in restaurants or from food bought at a supermarket. Any product, not just tech, runs into problems when manufactured at scale. Tech is more visible
124.
by mytherin 6y ago
I noticed the same a few years back. Now I only interact with Reddit through Apollo (iOS app) which allows me to add heavy filters, removing most subreddits and removing posts containing certain keywords. Anytime I see any FUD content on a
125.
by mytherin 6y ago
So if I sell my laptop that still has some photos on it, the buyer would own the copyright over those photos because they own the laptop? If I deleted the photos from the laptop, but they used a recovery tool to restore them from the disk,
126.
by mytherin 6y ago
> So just to be clear: I'm not sure if it's a good idea or not, probably leaning towards good, but with a bunch of considerations in mind: selling their things second hand or even giving away is what people also have been doing
127.
by mytherin 6y ago
Read the article again: > Ikea will soon be selling pre-used versions of some of its best sellers > Ikea said that anything that cannot be resold will be recycled. Recycling is a last resort here, the primary news here is that IKEA is
128.
by mytherin 6y ago
Should be fixed now. This was an old bug related to filter pushdown into scans. The demo now runs the latest version of the system. Thanks again for the report!
129.
by mytherin 6y ago
Thanks for your detailed reply! As you mentioned - lessons learned by SQLite here are indeed crucial. We are very carefully trying to craft a storage format before fixing it in-place, specifically to try to avoid these problems. Backwards c
130.
by mytherin 6y ago
Definitely. We have quite detailed plans for compression :) more to follow when we get to it.
131.
by mytherin 6y ago
We already have support for LIST and STRUCT (which I think are equivalent to ARRAY and ROW, respectively). There is still some functionality missing there (notably storage, and several functions) - but the base functionality is there and th
132.
by mytherin 6y ago
Yes, totally possible. You can use UNION ALL to merge them together. We are also working on globbing support for the Parquet reader that should be released next week [1]. [1] https://github.com/cwida/duckdb/issues&
133.
by mytherin 6y ago
Excellent, thanks again for writing them :)
134.
by mytherin 6y ago
Looks like a bug, likely related to an optimizer since adding count(*) does produce the correct result. I will have a better look after the weekend. The demo runs a relatively old version so it’s possible it has already been fixed in the me
135.
by mytherin 6y ago
Those formats have a different use case from a database system - they are mostly designed for write once, read many times workloads. As far as I’m aware you cannot update them in an ACID compliant manner, for example, which makes it difficu
136.
by mytherin 6y ago
We are currently actively working on performance optimization, and have recently finished implementing parallelization. Expect more performance improvements soon :)
137.
by mytherin 6y ago
Generally you would need to write bindings for the system. Experimental DuckDB bindings for Go do exist [1], however, they are rather old and might not work anymore. We also have JDBC support, which might help for languages that know how to
138.
by mytherin 6y ago
Neither Hannes nor me are very experienced with Go, so we are not the most suitable to do that. We do very much welcome external contributions, and someone did make a WIP go driver [1] in the past. We also have a sqlite3 compatible C API th
139.
by mytherin 6y ago
Foreign keys are not supported yet in DuckDB currently, but we do plan to add support for them in the future. If you have a need for them, feel free to post a comment on the issue. We tend to prioritize implementing features that many peopl
140.
by mytherin 6y ago
Thanks for reporting that! We will have a look at fixing it :)
141.
by mytherin 6y ago
One of the authors here - portability of the storage is indeed one of our goals. We test that the same file can be loaded everywhere on different systems, including between ARM and x86. I should mention the storage is still very much a work
142.
by mytherin 6y ago
One of the authors of DuckDB here: we use the PostgreSQL parser, and try to be generally compatible with the syntax used by SQLite, Postgres and MySQL. In some cases those are unfortunately mutually exclusive (e.g. null ordering - we have a
143.
by mytherin 6y ago
Regulation has little to do with it. Most of the tech industry is inherently winner-takes-all or winner-takes-most because of how easy it is to scale up tech solutions. US companies get a huge head-start because of their large home market c
144.
by mytherin 6y ago
Nintendo doesn’t sell at a loss - only Sony and Microsoft do. Both are huge multi-billion dollar companies that entered the console market using money they had from other ventures. There is also effectively no other competition on this mark
145.
by mytherin 6y ago
Perhaps monopoly abuse is not the right term, but Microsoft did buy their way into the gaming industry by selling millions of consoles at a loss. There is no way for any company that is not already a multi-billion dollar company to compete
146.
by mytherin 6y ago
The same is likely true of Fortran, since Fortran code is shipped around with several Python data science libraries and included in R. Does that mean Fortran is a thriving language, or does it just mean Fortran was used a long time ago to w
147.
by mytherin 6y ago
No doubt it is, I'm just explaining why comparing Chrome to Internet Explorer makes a lot of sense. Having a single browser used by the vast majority of people is a bad situation to be in. Especially when that browser is developed by a
148.
by mytherin 6y ago
Internet explorer was actually a decent browser in its peak. The whole "dragging things down" happened later on because people kept on using really old versions of IE (mostly the one bundled with Windows XP). The main problem with
149.
by mytherin 6y ago
There are also online-only versions of consoles that don’t have a physical disk drive and have to go through the locked down online store, like the recently announced Xbox Series S.
150.
by mytherin 6y ago
> It's not the moderation, it's the moderation combined with effectively gating the ability to run a competing marketplace. > Apple does this through linking all the components of the stack, their store requires their OS whi

More ›