Hacker Newsnew | past | comments | ask | show | jobs | submit | threesquared's commentslogin

I worked at a company who made charging points a few years ago and the consensus then was that the idea of charging on the road at petrol stations was outdated.

Chargers need to be where you park for an hour or more, so at the home, destination or basically where there are car parks.


Absolutely true for short distances (e.g. a daily commute), but not when you travel a long distance. If you want to cover say 1000km in a day, you probably need to charge twice along the way. Fast chargers along the highway are perfect for this.


What does "70 health interventions were made" mean?


A health intervention is usually any action taken to increase the health of the subject.

In this case, I think they're talking about referring people to rehab or other treatment for substance abuse.


You might want to check out something like https://photoprism.app/


I bet that the accuracy and user experience are nowhere as good as Google Photos. Which is sad.


But honestly what do you do when your application monolith outgrows its relational database. This seems to be the main reason to split concerns into their own services. Relational DBs don't scale horizontally.


Why would you use Postgres for this which doesn't horizontally scale when you could easily index documents in ES and use that for full text search?


If you only need modest search functionality and you don't want to manage another service/system, Postgres full-text search may be for you.

http://rachbelaid.com/postgres-full-text-search-is-good-enou...

I read this article about 6 years ago and after an afternoon I added full-text search to the app I worked on at the time. 6 years later, it's still the only search they use. This small tool already built into postgres has been more than enough for us.


I've had similar luck with sqlite, of all things. Unless it's envisioned to handle huge user loads, sqlite does a pretty amazing job of FTS, all contained in a tiny binary that runs when I want and only when I want. I find it very useful for finding nuggets in titles and descriptions, spanning across thousands or millions of records. the index is often double or even triple the size of the database, but its worth it for a query that returns in a heartbeat.


For static databases (especially where the content is not deleted, or rarely updated) consider using contentless tables or external content tables. The database size remains virtually the same, but you'll have immediate access to almost all FTS features.


I worked on a project where we needed to search in a set of approximately 2,5M addresses, and return the adresses' approximate coordinates. We already used postgres for our other database needs, so slotting this in in our existing stack took us all of a couple days.


Most projects will never scale horizontally.


Most projects will never *need* to scale horizontally.

Unfortunately, many will, due to FOMO and Resume Driven Development.


Good point :)


Why is "sound simulation software" illegal in China?

https://github.com/github/gov-takedowns/blob/master/China/20...


It appears these repository allows you to create synthetic speech of Xi Jinping, you can now see why Chinese Government might wanna take that down.


There's also a game mocking xi


> We like the idea of zero trust and provable perfect end to end encryption. But would prefer it to be based on vendor trust, unverifiable, imperfect by design and have a man in the middle.


The entire point of a datacenter is tenant isolation and security. Plus the fact there are few user workstations and physical access is extremely restricted.


The staff of the data center also have computers not just the tenants, which the question can also be about


I love how the meta description still says "Web site created using create-react-app"


If anyone else was interested there is a virtual tour of the Cambridge Library Storage Facility

https://www.youtube.com/watch?v=EH_rmdeTCWY&feature=youtu.be


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: