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.
Ask HN: What problem are you close to solving and how can we help?
91–100 of 486 posts
Re: Ask HN: What problem are you close to solving and how can we help?
#92I 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…
Re: Ask HN: What problem are you close to solving and how can we help?
#93Earlier 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.
Re: Ask HN: What problem are you close to solving and how can we help?
#94I 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…
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?
#95How 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/
(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?
#96I 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…
Re: Ask HN: What problem are you close to solving and how can we help?
#97Here'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?
#98I'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…
Re: Ask HN: What problem are you close to solving and how can we help?
#99How to get my kids to bed to bed.
Re: Ask HN: What problem are you close to solving and how can we help?
#100It's called Code Shelter:
It's stalled for a while, so I don't know how viable it is, but I'd appreciate any help.