Live data from Hacker News

Ask HN: What problem are you close to solving and how can we help?

news.ycombinator.com

91–100 of 486 posts

Re: Ask HN: What problem are you close to solving and how can we help?

#91
post #7
post #3

Earlier quoted context omitted.

imo, json dt should be an intermidiary step in db struc in rdb, never the final. Once you know & have stable columes, unravel the json into proper cols with indexing, it should improve the situation if youre having issues with 5gb, you will face exponential problems when it grows due to lack of indexing

Cheers for the response (and affirmation). After some latency profiling I am convinced proper cols with indexing will vastly improve our situation since the queries themselves are very simple.

Depending on how much of the data in your json payload is required, extract data into their own table/cols. And store the full payload in a file system/cloud storage.

Re: Ask HN: What problem are you close to solving and how can we help?

#92
post #80

I am working on two problems: 1. I want to create way to generate electrical power without pollution. Basically, a closed cycle process that releases no pollutants, or electronic waste. 2. I want to do everything I can to eliminate gender bias in the world.

Regarding 1, if you can accept some pollution at the beginning, hydro-electrical can be a solution, albeit probably not for a global scale. We have a small hydro-electrical plant una River near my house and really it's no big deal, it fits very nicely in the surrounding environment and it produces clean energy. It's also educational because since the river is near the city small children classes can visit it and lear…

Regarding hydro, you can go micro to power a house or some small comunity. There are lot's of books on microhydropower, but get a look at this fantastic post at ludens.cl

http://ludens.cl/paradise/turbine/turbine.html

Re: Ask HN: What problem are you close to solving and how can we help?

#93
post #7
post #3

Earlier quoted context omitted.

imo, json dt should be an intermidiary step in db struc in rdb, never the final. Once you know & have stable columes, unravel the json into proper cols with indexing, it should improve the situation if youre having issues with 5gb, you will face exponential problems when it grows due to lack of indexing

Cheers for the response (and affirmation). After some latency profiling I am convinced proper cols with indexing will vastly improve our situation since the queries themselves are very simple.

Also there's a way to profile which queries take longest via DB itself and then just run EXPLAIN ANALYZE to figure what's wrong

Re: Ask HN: What problem are you close to solving and how can we help?

#94

I want to bring back old school distributed forum communities but modernise them in a way that respects attention and isn’t a notification factory. Mastodon is a pretty inspirational project but the Twitter influence shows, I miss the long form writing that was encouraged before our attention spans were eroded. Not at all close to solving it, but it’s been on my mind for a long time. Would love to hear if there are o…

I tried this, got quite far. Will go a little further when I have spare cycles for it.

Example: https://www.lfgss.com based on code you'll find on GitHub under microcosm-cc

Re: Ask HN: What problem are you close to solving and how can we help?

#95
post #35
post #11

How to get my kids to bed to bed.

Try the 28hour day. Once your kids are sufficiently tired, they'll go to bed by themselves. https://xkcd.com/320/

... not a parent?

(The only thing worse than trying to get a child who isn't tired to go to sleep is a child who is too tired to go to sleep.)

Re: Ask HN: What problem are you close to solving and how can we help?

#96

I want to bring back old school distributed forum communities but modernise them in a way that respects attention and isn’t a notification factory. Mastodon is a pretty inspirational project but the Twitter influence shows, I miss the long form writing that was encouraged before our attention spans were eroded. Not at all close to solving it, but it’s been on my mind for a long time. Would love to hear if there are o…

I'm very interested in this space too. I want to start a project that explores different ways to communicate on the web. The current state of Facebook and Twitter are not the best way in my opinion.

Re: Ask HN: What problem are you close to solving and how can we help?

#97
I could use some help with some heuristics for Machine Learning, like how much data do I need to make a workable model, what framework/approach makes more sense given my ultimate goals.

Here's an example: there's a lot of ML tutorials on doing image identification. Like you have a series of images: picture one might have an apple and a pear in it, picture 2 might have an apple, orange, and a banana in it.

Where I'm struggling is putting this into my domain. I have a 100k images and from that around 1k distinct labels (individual images can have between 1 to 7 of these different labels), with between 13,000 to 100 images as examples in each label.

Is that enough data? Should I just start working on gathering more? Is this a bad fit for a ML solution?

Re: Ask HN: What problem are you close to solving and how can we help?

#98

I'm looking for a way to integrate a React app with an existing Vue... thing. Don't really need any communication between the two, just displaying it would be fine. My issue is: the Vue code just throws in tags in the html and expects global variables (location instead of window.location), while the React code uses ES6 imports. The only partly working way I found is including tags with a useEffect, but that doesn't p…

Have you tried SingleSPA? I’ve used it in the past to get React apps inside an old AngularJS app to replace parts of it over time and it worked pretty well. Docs say it works with Vue as well but I don’t have any direct experience with Vue at all far less for this kind of task so I’m not really sure it will work but it is worth looking at https://single-spa.js.org/

Re: Ask HN: What problem are you close to solving and how can we help?

#100
I built a community that aims to keep FOSS projects alive. It's meant to solve the kitchen and egg problem by having as many people and projects sign up, and then any developer who was interested could just automatically get commit permissions to any project.

It's called Code Shelter:

https://www.codeshelter.co/

It's stalled for a while, so I don't know how viable it is, but I'd appreciate any help.

Post reply on HN