hantusk

6 ms·

31.
by hantusk 3y ago
That's not true for postgres scanning: https://duckdb.org/2022/09/30/postgres-scanner.html So i would think we'd see similar speedups for sqlite even without copying any data
32.
by hantusk 3y ago
I thought the API here was quite neat. It's fairly simple to implement a lancedb backend for it instead of sklearn/faiss/mrpt as the source code is really simple. This repo is basically just a nice api and the needed chunking
33.
by hantusk 3y ago
check out Daniel Gross's https://github.com/danielgross/localpilot
34.
by hantusk 3y ago
The Pareto principle is about the converse as well
35.
by hantusk 4y ago
https://github.com/jeffknupp/sandman2 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.
36.
by hantusk 4y ago
When reading through the comments here, I really feel like the article was misunderstood. My summary of the article is: Point 1: React solved all the right things, but its current trajectory, does not prioritize developing the fundamental t
37.
by hantusk 4y ago
Postgres can do the"function over (partition by col_a order by col_b) as well. Agree, SQL can already do what the OP proposes in almost the exact same syntax. and together with CTEs, intermediate temp tables or views, you can totally a
38.
by hantusk 4y ago
Hm, i found this to be pretty straight forward through Docker: e.g: FROM caddy:2-builder AS builder RUN xcaddy build \ --with github.com/greenpau/caddy-security FROM caddy:2 COPY --from=builder /usr
39.
by hantusk 4y ago
Me too! It had a cheat code, so if you set the power to a certain amount it would shoot through the grass
40.
by hantusk 4y ago
Same pattern is ActorDB: https://github.com/biokoda/actordb
41.
by hantusk 5y ago
Not a big fan of SQL dsl's personally. If you feel you'd need a better query syntax and plotting for interactive use, I'd suggest looking at the dataframe libraries that have a larger community to discover how to solve things
42.
by hantusk 5y ago
Gitlab just IPO'ed this year. It seems unlikely, that this would be a motivation.
43.
by hantusk 5y ago
a path I haven't explored yet is Koalas, which touted a 80% API compatibility with pandas at version 1.0. Now its at version 1.8, and it has the pandas API as the main design principle for function interface design. https://
44.
by hantusk 5y ago
this benchmark is more comprehensive for this type of analytical work: https://h2oai.github.io/db-benchmark/
45.
by hantusk 5y ago
we're not far away :) https://twitter.com/nshepperd1/status/1446004530433323018 There's a notebook too, if you're curious
46.
by hantusk 5y ago
Does it not work with miniforge/mambaforge? ( https://github.com/conda-forge/miniforge ) I use this with my m1 mac, and it works great.
47.
by hantusk 5y ago
I hope kinks have been worked out. z-index errors, sync not working for some participants and JavaScript alert windows about losing data, were issues the three times I've used it with my team, so i basically dont dare suggest my team u
48.
by hantusk 5y ago
Agreed. https://ibis-project.org/ and https://dbplyr.tidyverse.org/ can compile dataframe-like input to SQL, which might bridge the gap in tooling (although there still are small differences to the pure dat
49.
by hantusk 5y ago
I use mermaid: https://mermaid-js.github.io/mermaid/#/ And excalidraw: https://excalidraw.com/
50.
by hantusk 6y ago
I would go for decrappify: https://www.fast.ai/2019/05/03/decrappify/ GAN's are hard to train for a new ML practitioner, VAE can have blurry results if you are not using skip-connections like in U-N
51.
by hantusk 6y ago
Neat! you could prototype out the db in sqlite, and then have sqlalchemy introspect and write out a db-agnostic model from this. Happy to see the support around foreign key relationships and lookup tables here. Thanks!
52.
by hantusk 6y ago
Yeah, see: https://dataset.readthedocs.io/en/latest/ It doesn't do foreign relationships though, guiding you to use sqlalchemy when you reach that level of complexity. It works for all databases supported by
53.
by hantusk 6y ago
This. Wholly agree. Currently running a large labelling task with 12 labelers. Using Amazon ground truth which works fine (although seems quite MVP outside the core functionality e.g wrt reporting or user creation). What tool have you had s
54.
by hantusk 6y ago
.. and your phone already does this: https://www.google.com/amp/s/www.macworld.com/article/344463... Also, im sure I saw a very nice video on this, with a car driving through the landscape, using previou
55.
by hantusk 6y ago
Wow, totally opposite my view. As a family we always want to stay somewhere with a kitchen and a private lounge area - hotel suites are cost prohibitive to this, and a lot less charming. When finding chalets or cabins/lodges for outdoo
56.
by hantusk 6y ago
Just use TEXT in other databases as well. It really shouldn't matter much in modern dbs
57.
by hantusk 6y ago
Audiobooks in Kindle is at linked to the text, so its easier to skim pages for where you dozed of. Best solution I've found so far.
58.
by hantusk 6y ago
Also, don't add salt until the process is finished, as that also makes it more starchy
59.
by hantusk 6y ago
Isn't it possible to buy most high-end smartphones with 256 gig of RAM?
60.
by hantusk 6y ago
I'm really fond of https://altair-viz.github.io/ which wraps and translates into https://vega.github.io/vega-lite/ . The interactivity and cross-filtering possibilities is really good when you have

More ›