Live data from Hacker News

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

news.ycombinator.com

61–70 of 486 posts

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

#61
post #46

Problem: Create image with text. Solution: https://img.bruzu.com?a.t=Text You can help by trying the API and giving honest feedback. https://bruzu.com

It seems kind of interesting, what are some use cases you've seen for it?

Use cases:

1. Image generation automation: Like into automation like posting tweets as image to instagram.

2. Image generation scaling: Create multiple images with just variable text, like greeting messages or product images or open graph images.

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

#62
post #42
post #24

Earlier quoted context omitted.

Are you just doing primary key lookups? If so, a new index won’t do much as Postgres already has you covered there. If you have any foreign key columns, add indexes on them. And if you’re doing any joins, make sure the criteria have indexes. Similarly, if you’re filtering on any of the nested JSON fields, index them directly. This alone may be sufficient for your perf problems. If it isn’t, then here’s some tips for…

This is super interesting stuff. First of all, I think the caching layer (which we currently don’t have) is going to be a necessity in the coming weeks as we scale for an additional project (that will be relying on this architecture) Second of all, it is just PK lookups. We don’t actually have a single fk (contractor did not set up any relations), which makes me think moving all of this replicated JSON data from fiel…

I do want to emphasize that the S3 approach has a lot of trade offs worth considering. There is something really nice about having all of your data in one place (transactions, backups, indexing, etc... all become trivial), and you lose that with the S3 approach. BUT in a lot of cases, splitting out blobs is fine. Just treat them as immutable, and write them to S3 first before committing your DB transaction to help ensure consistency.

Regarding JSON schema, if you have a Marshmallow schema or similar, yes that’s a wonderful starting point. This should map pretty closely to your DB schema (but may not be 1-to-1, as not every field in your DB will be needed in your API).

I’d suggest avoiding storing JSON at all in the DB unless you’re storing JSON that you don’t control.

For example, if the JSON you’re storing today has a nested object of GPS coords, temperature, etc.. make that an explicit table (or tables) as needed. The benefits are many: indexing the data becomes easier, the data is stored more efficiently, the table will take up less storage, the columns are validated for you, you can choose to return a subset of the data, etc… You will not regret it.

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

#63
Ok, I'm double dipping. Another problem I'm trying to solve is: I've got a database of several hundred interesting conversation questions that I've collected over the years. Essentially just strings, though I've attempted to categorize them, rank them, and add other metadata. I'd like to figure out a way to sort them or dedupe them based on semantic similarity, but I'm not sure how to determine semantic similarity without painstakingly going through and manually looking for similar questions. Any suggestions on how to solve this would be welcome.

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

#64
post #6

We are working on a totally new way to do cold fusion, our only problem is getting enough new fuel into the reactor without disturbing the running process. Any help would be greatly appreciated.

Maybe the solution is in your fridge?

... Not being flippant; I find that these kind of prompts can help in thinking from a new approach.

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

#66
post #63

Ok, I'm double dipping. Another problem I'm trying to solve is: I've got a database of several hundred interesting conversation questions that I've collected over the years. Essentially just strings, though I've attempted to categorize them, rank them, and add other metadata. I'd like to figure out a way to sort them or dedupe them based on semantic similarity, but I'm not sure how to determine semantic similarity wi…

Put the questions in some semantic embedding space. Now you’ll have a vector representing each question. Then for each question, you can sort all the questions by how far the Euclidean distance is between their vectors. Or use some clustering algorithm like k-means to find clusters.

By web search I found this to tutorial to put sentences in an embedding space: https://github.com/BramVanroy/bert-for-inference/blob/master...

I did not read this and am not endorsing it, but it looks like it’s doing roughly what I’m suggesting.

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

#67

I'm looking for the best way to implement Multitenancy, Submultitenancy Impersonation with JwtTokens and IdentityServer4 ( dot net). I'm curious on how other people solved it ( by cookies, subdomain, ... ) and if you used a JwtToken for it.

Looking for something like authzed.com?

I've got the database and query part covered.

But I haven't decided yet on the actually flow. Where I'd identify the current tenant or impersonate him.

+ The influence of impersonation on that flow.

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

#68

I have posted this here before- hexafarms.com. I am trying to use ML to discover optimal phenotype for growing plants in vertical indoor farms to a. have the higest quality produce b. to lower the cost of producing leafy green/med plants, etc. within cities itself. Basically, every leafy green (and herbs, and even mushrooms), can grow in a range of climatic condition (phenotype, roughly) ie temperature, humidity, wat…

I'm not able to help, but you don't have any contact details listed against your profile or in this post. How is anyone able to contact you?

At the very least what's a link to your startup's website?

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

#70
Working on trying trying to extract the most benefit from my suicide while reducing the risk of of damage. Right now there's two issues:

* I'd like to donate my kidneys, liver, and lungs as a living donor. However I've heard that there may be a psychological screening component for being a living donor which may detect that I'm planing on killing myself and trigger intervention. Is there a way around it? It's not critical for success but it would be nice to give back to someone else a chance at life, but I'm not sure if it's doable.

* I want to minimize the possibility of being discovered and identified after death. I've selected a heavily wooded site that's time consuming to access on foot and selected timing to be early autumn some years from now once I've acclimated my acquaintances to my absence. The concern however comes from the fact that I have a security clearance and my fingerprints are in the system. I'm trying to figure out if it's a real concern that my body is discovered with fingers intact, and what needs to be done to mitigate it. Or if seclusion, exposure, and scavengers are enough to cover that possibility and it's not a real concern.

Post reply on HN