asadawadia

9 ms·

31.
by asadawadia 4y ago
Does this only optimize things like `select * from table where false` type stuff or can it optimize access paths as well? such as whether an index can be used? and what ranges? or should a sequential scan be used
32.
by asadawadia 4y ago
sql can be arbitrarily nested/deep - so how does the code 'know' what to do
33.
by asadawadia 4y ago
This comment might be confusing - I misread what the question was I feed the cat for good karma The picture stuff was to get a notification to tell when it was coming to eat
34.
by asadawadia 4y ago
Go for it! You can piggy back on my object detection api - it can detect birds - just tried with the image => https://images.unsplash.com/photo-1520638023360-6def43369781... Request example => https://paste
35.
by asadawadia 4y ago
Good karma mainly
36.
Cats, Pi, and Machine Learning(blog.aawadia.dev)
61 points by asadawadia 4y ago|14 comments
37.
by asadawadia 4y ago
There is a cat that wanders around my neighbourhood. I wanted to build something that would notify me whenever it came to my backyard. The post describes what I did
38.
Find/Search Reddit conversations/comments(conversations.aawadia.dev)
1 points by asadawadia 4y ago|1 comments
39.
by asadawadia 4y ago
I started working on a website that can serve as a library for videos that are more conversation oriented. Logged in users can submit, search, like, comment, and browse right now As part of this, I realized I search comments on reddit to f
40.
by asadawadia 4y ago
I really enjoy the form of content where it is a casual laid back conversation so i started working on a website that can serve as a library for these kinds of videos. I am going to continue building out the features and the content library
41.
Curated Conversations(conversations.aawadia.dev)
1 points by asadawadia 4y ago|1 comments
42.
IndieRPC: Library to make 1000 poorly batched RPCs to render a home timeline(github.com)
2 points by asadawadia 4y ago|0 comments
43.
by asadawadia 4y ago
Only 500MB of storage [same as DigitalOcean's free repo] - which isn't enough
44.
by asadawadia 4y ago
Thank you :)
45.
Self hosted Docker registry with auto image push on push to main(blog.aawadia.dev)
55 points by asadawadia 4y ago|13 comments
46.
by asadawadia 4y ago
For anyone who wants to get started with this stack you can do `git clone https://gitlab.com/asad-awadia/kotlin-server-app.git ` to get a full maven project with javalin, sqlite with ktorm and jdbi everything setup
47.
by asadawadia 4y ago
love it
48.
by asadawadia 4y ago
do people want a SQL DB over HTTP?
49.
by asadawadia 4y ago
is it because you couldn't find a DB that you could talk to over http[s]?
50.
by asadawadia 4y ago
Mentoring and helping is not predatory
51.
by asadawadia 4y ago
>understand terms? What do you mean understand terms? If you need help with programming check out the link in my profile and we can set some time up - it will be more beneficial than buying a book
52.
by asadawadia 4y ago
are you a frontend dev?
53.
by asadawadia 4y ago
Safekeeper to page servers take some time what happens when the compute server issues a read for something that has made it to the WAL servers but not the page servers?
54.
by asadawadia 4y ago
if storage and compute are separated - how is storage mounted on to the compute? Generally you can attach a volume only to one server at a time
55.
by asadawadia 4y ago
what exactly is the value proposition upon which you can raise millions?
56.
by asadawadia 4y ago
the guy forgot to press shift on the last 1 lol
57.
by asadawadia 4y ago
the fundamental problem with counters is that it does a read-modify-write cycle which is quite harsh on the DB - a better approach is to take advantage that counters are cumulative and we can keep the delta events only and 'merge'
58.
by asadawadia 4y ago
Yeah, saves you from thundering herd problems https://github.com/ben-manes/caffeine cache does something similar by caching the future that gets returned on look-ups if the value is still being computed
59.
by asadawadia 4y ago
>Fits well in a lot of use cases. Can you share the use cases? Why Mongo works better than Postgres?
60.
by asadawadia 4y ago
Awesome! Readers can try out this against my websocket chat server at: wss://wschat.aawadia.dev/chat/<roomName>/<nickName> HN room at `wss://wschat.aawadia.dev/chat/hackernews&

More ›