skysight-inc/HackerNews huggingface dataset:
The ugly truth behind ChatGPT: AI is guzzling resources at planet-eating rates
Great point.

The advantages of loading “parquet” in “client side” are that 1) you only have to load data once from server and 2) the parquet files are surprisingly well zipped.

1) If you load once from server, no more small network requests while you are scrolling a table. Moreover, you could use the same duckdb table to visualize data or show raw data.

2) Sending whole data as a parquet file is faster through network than receiving data as json in response.
https://www.youtube.com/watch?v=QmLekaO4LMc

from an economics professor who examines the evidence about what is causing the trade war between china and the west.

The main thesis is that car manufacturing (and associated manufacturing such as batteries, electronics etc) is "strategic" enough that the west doesn't want to build a dependence on china for it.

In the event of a war, china can cripple the west by cutting off the exports, and/or potentially install backdoors into the devices and shut them down to disrupt etc.

Not to mention that by allowing china to own the manufacturing, they will have built up the massive industrial capacity for which it is easy to convert to a war time factory. The west's dwindling manufacturing capacity would mean that china will out-produce and win - lessons that is learnt from WW2.
As a counterpoint, $500k+ is definitely achievable if you're interviewing as an L5 at a FAANG. It has been for a few years, actually. Of course you'll need to negotiate, maybe have a few counteroffers, but it's doable.

I get being disappointed about $300k. Many companies are offering that for non-seniors (Google L4 equivalent) now. I distinctly recall TikTok offering well north of $300k cash for just 2 YoE a few years ago, and Meta offers have risen similarly.

I'd also be pretty sad if I interviewed elsewhere as an L5 and got offered less than what I made as a 2 YoE L4 (and many years ago, prior to inflation at that.)
I'm not sure if it is exactly fondly, but access to Internet itself being treat made it lot more special. This was before family had ADSL. And there was still cost involved over going online. As such limited time made it more special.
This. And also, the problem is people want to have too much control. You should build your society in such a way that if you lose control (a bit), its no problem.
That is the real problem with tracking of parents and -for that matter- the security agencies.
You should raise your children to be resilient. If they get lost, teach them how to get unlost. They should recognize danger by the stories we tell them and the experiences they had. Sometimes this goes wrong, and that is super sad, but things go wrong in life. There is no real way of preventing things to go wrong.
We are now making sad human beings by putting our kids into a safe bubble.
This resonates.

As a frequent public speaker and coach of others in public speaking, the top priority is to just deeply understand the material. The second priority is to create the habit write like you publicly speak (i.e develop a style).

You put these together, and you have no choice but to explain it the way you’d have written it anyways. This enforces resilience against interruptions and allows for improvisation.

But this is hard. It requires two great efforts: to deeply understand the material, and to craft a speaking/writing habit that makes for powerful, public speaking.

It doesn’t surprise me then, that actors do the same.
This is not the overall US. This is a particular type of middle class suburb that is full of busybodies and helicopter parents.
https://archive.md/DPv9Q

(No paywall but buggy ad blocker detection)
Show HN: AI infused focus music for makers and entrepreneurs
That’s effectively what the documentary I saw concluded (it was a French documentary).

There is a big part of genetics to start with but the impact of the environment is so big that it can make the difference between no correction needed at all up until unmanageable myopia.

Of course you can have a genetic baseline that makes you even more at risk and sensitive but it seems that’s pretty rare overall.

Also I’m curious of what you call quite bad myopia. As an example, my myopia is currently around -7 or -8 and to my surprise, I’m the only one being myopic in my whole family tree. Even my son have a perfect vision.

And it’s true that when I was young, I wasn’t frequently outside and even more rarely in wide open areas.
Long story short, you could either 1) query specific columns using s3-parquet-duckdb stack 2) load parquet file through network, and put it inside local duckdb-wasm instance so that you can do queries from client side
> Costs of API maintenance - rigid APIs need constant change.

Rigidity is the point...

If you have a "CRUD a Foo" set of APIs, and how you create/read a "foo" is defined in that API. Sometimes change is necessary, sometimes the API contract changes, but sometimes just the internal implementation changes (eg new or refactored tables/columns). The rigidity of the API ensures that every downstream user of a foo creates/reads in the exact same way. It centralizes permissions, overrides (eg. a/b testing), rate limiting, transactions, etc. to be homogeneous for everyone. If you want to create/read a foo via database queries alone, and the database changes or the business logic changes, then the same issue occurs where all clients need to change, but now it needs to be coordinated everywhere, and you can't benefit from a centralized change hiding implementation details.

Many people prefer to keep all the logic around enforcing consistency and object lifecycle (application behavior) in the application layer. This allows a single codebase to manage it, and it can be uniformly guarded with tests. Exposing the database itself is really just an example of a leaking implementation details.

> To mitigate that people create APIs like GraphQL

If you need raw flexible queries, then this is probably the wrong sort of solution. Ideally, the developer of a service already knows what queries will be made, and clients don't typically need detailed custom queries. Analytics (typically read-only) should already occur in an offline or read-replica version of the database to not impact production traffic.

> (micro)systems owning databases need data synchronisation and duplication.

What do you mean? Foo service exposes "CRUD-Foo" apis and is the only service that calls the Foo-storing database. If Foo service is horizontally scaled, then it's all the same code, and can safely call foo-db in parallel. If the database needs horizontal scaling, you can just use whatever primitives exist for the database you picked, and foo-service will call it as expected, and the transaction governs the lifecycle of the records.

> ...all efforts to decouple services via APIs are moot.

To be clear, different services wouldn't operate on their own duplicated version of the same shared data, in their own database. They'd call a defined API to get that data from another service. The whole point of this is to allow each service to define the interface for their data.
I heard that the iPhone landscape was not fragmented though.
You won't notice much performance benefit (because WordPress doesn't support worker mode yet), but it is simpler to run and deploy (single binary) and you get all the benefits of Caddy out of box too, like TLS automation.
nah not questioning containers. questioning why he wrote 8 (obviously exaggerated) and why it’s not 1.
Seems that the easiest solution to mentioned office problems would be to have a common plastic teaspoon printer.
It doesn't matter if it's just one end of the spectrum. By pointing this out, you either are or appear to be riding the issue on behalf of the other end. This causes them to close ranks and dismiss it as partisanship.

Besides, Russia has changed its backing preferences over time. Just look at the frivolous moral gymnastics Oliver Stone has been performing from around Putin's arm.
Many non Go Web developers know about static compilation, before shared objects were even a feature in mainstream OSes.
Did you get any response from Go core team? Might make sense to open issue in GitHub https://github.com/golang/go/issues/ and start thread in https://groups.google.com/g/golang-dev
Would you want to be tracked 24/7? Your argument is basically the nothing to hide fallacy
Ask HN: Do you look at GitHub stars before getting into a repo?
Of course stars don't equal to the quality of the repo or work done by the community but time and again I do find myself glancing over stars to make a call if a repo will be a good idea to explore or not.

I tend to do this especially with linux tools available - partly my reason is security related and partly vanity metrics I guess

how about you?
Google and partners are rolling out their own network now: https://9to5google.com/2023/05/10/android-find-my-device-tra...
did you miss this part in Frankenphp website ? :)

Build standalone, self-executable and dependencies-free binaries for your PHP web applications, and command-line tools.
Among people that have used nothing besides scripting languages.
Largest ever operation against botnets hits dropper malware ecosystem
In a closed system, you could grow the commons until there's no scarcity anymore, and thus no tragedy either. This stops working once some "entrepreneur" figures your commons is their arbitrage opportunity, and opens the system to the outside world.
BCL and BLC were created solely by me.
And Haskell (like Pascal) is indeed a cool name.
Final Association Query Solution
Hadn't heard of this - it looks very interesting. Thanks for the reference!
Modern SQLite: Secure Delete
People seem to forget a lot that child math prodigies are being trained by parents to be math geniuses instead of enjoying being a kid. I had a 12 year old in my freshman CS class and he was the most miserable unhappy kid I've ever seen in my entire life.

Edit: Pretty good points in the replies. Probably a lot of latent jealousy on my side in this. I should have thought on this more before commenting.
Or - A bi gpart of parenting is making sure the kids understand why they have to go to school and how lucky they are to be able to.

(but I 100% agree with you, trust is not achieved with panopticon control)
How stable is the DuckDB file format nowadays? One annoying thing I've experienced (like a year ago) was when I upgraded the rust bindings that produced my DuckDB files, which then couldn't be opened with DBeaver because they hadn't released a new version yet.

I guess you could run into something similar with this solution?
> I gave feedback to Waymo about a recent ride where the entire car smelled like a fat, unwashed ass

Knowing BigCo reputation, I think it’s equally possible that Waymo and/or BigCo accounts will be banned for actual perp, complainant or random rider in-between… what a world…
Google is starting to roll out a Find My Device network, but it's been delayed so the trackers are just now shipping and there aren't yet reviews out on how good they are.
I find it difficult to imagine ubiquitous surveillance not shaping behavior and thought.

I was born in the mid 90s and remember some of my friends getting flip phones in the early 2000s. One friend was given a phone that would report its location to their parents, presumably through some web-portal. I vaguely remember the conversation where my friend told me about this phone and the location tracking, and I remember the uncomfortable feeling that new idea provoked. I believe that reaction is a natural one to the idea of being followed everywhere you go, but that reaction is only possible if the idea hasn't been normalized from birth.

Just because surveillance is largely ubiquitous and societally normalized doesn't mean it has no impact, and that impact is unlikely to be articulated by those experiencing it.
Mustang was 309201 USD in US and around 119929 USD in India. They offer lower variants in US and only higher variants in India and the "American Icon" badge goes far. There are massive taxes on completely built units too.
It teaches the wrong thing to both parent and child.

Parent gets hooked on surveillance rather than trusting their kid to be independent. The “safety net” is actually a mental crutch imho.

Child thinks 24/7 surveillance is ok or resents their parent as they get older since they are always being watched.

Not to mention that tracking is unlikely to really save a kid in a life or death situation that is any reasonable level of risk (like a car accident).
If you have smaller kids, most taxi rides are completely illegal in any western country and very dangerous for kids. Ever saw a taxi with 2 spare child seats or at least boosters? They are required by law for very good reasons, and those reasons are kids dying or ending up crippled even in relatively mild crashes.

That's just one tiny example out of sea of examples.
Exactly.

We have also tried arrow js or parquet wasm, and they were much lighter than duckdb wasm worker.

DuckDb however was useful in our case, considering our nature as form builder service, we had to provide features for statistics. It was cool to have OLAPS inside a webworker that could handle (as far as we checked) more than 100,000 rows at ease.
GO + HTMX + standard templates... or some folks swear by templ

On the API side (not what you wanted, but good looking) is sqlc + validator

Between all of those you have everything you want for a website.

Week 1 go is going to be a lot slower than Django or Rails. You're going to have a bit of bootstrapping to do for your project. By the end of the first month you will be a week or two behind but performance parity will be the same (you should have roughly the same feature cadence).

A good framework brings a lot to the table. With go you have to "solve" for that yourself. "How do I log a request" would be one of those first questions... the answer is "the standard logger is pretty good" and "Middleware is awesome". It's a question that has a simple, short, very common answer. One that works for web apps or CLI apps or ... It takes a bit but you end up embracing the idea that less is better
> Just to turn off the possibility of table scans on that individual table in all environments

I do not remember the name but there was a sorta pg-compatible database started a few years ago that intentionally did not support non-indexed queries and if you tried a query for which a index was available it would create it before running the query (and keep it live for some time).

I thought it was an interesting tradeoff (even if likely not the one I would choose) a signigicant lag spike followed by better performance rather than a uniform degradation over time.
I know that at least two engineers from the runtime team have seen the post in the #darkarts channel of gopher slack. One of them left a fire emoji :).

I'll probably bring it up in the by-weekly Go runtime diagnostics sync [1] next Thursday, but my guess is that they'll have the same conclusion as me: Neat trick, but not a good idea for the runtime until hardware shadow stacks become widely available and accessible.

[1] https://github.com/golang/go/issues/57175
The Go container provides an environment in which to run Octane. Your webserver still needs to know to reroute traffic appropriately. You can think of FrankenPHP as more of a webserver/app server all bundled into one binary.
Meaningful Nonsense: How I generate sentences
Native graphics debuggers like those integrated into Xcode (for Metal) or Visual Studio (for D3D) allow shader step-debugging, as well as RenderDoc (but AFAIK not for all 3D APIs).
> version 6

PHP6? That was long ago because I don't even remember it!

I don't have much to say otherwise, except you could very well say the same "Go is great" without having to shit on PHP and the project that is being discussed here.

Especially since you don't really come off as very knowledgeable on what you're talking about.
I have a tinypilot kvm. It's a nice network kvm that's pretty easy to get going. For example, it does 1920x1080 resolution immediately. I would use it more often, but it is loud - louder than the servers I hook it to.

I switched to pikvm which has a little less polish, but you can put together much cheaper. It is even more hackable. For example, connect to 4-port kvms that have RS232 and you can run 4 systems.

tinypilot seems to have some serial or order number that you need to download an update. pikvm seems to reserve some features for hardware they sell (for example, they don't seem to want to support HD resolution, even though you can just move an edid file and support 1080p at less than 60hz).

Both of them are or at least started as raspberry pi kvms with an HDMI-in digitizer (either csi or usb) and hardware hacks to use the usb power port to emulate usb devices (keyboard/mouse/drive)
after hearing that the prius cvt didn't use a belt I had to watch a few youtube videos on planetary gearsets - mind bending stuff and dead simple to boot!
Show HN: Custom AI Chatbot for customer support and lead generation
Hi everyone ,

I'm launching this Chatbot builder tool to help you build an AI Chatbot without coding, it's powered by ChatGPT or Llama 3 from Meta. Your AI Chatbot can help run your business with customer support and lead generation.

You probably already seen similar products on the market and wonder what makes this new product a better choice. I've been working to make this chatbot platform better than competitors by implementing advanced features like Short and Long term memory that is going to help make the bot work even better.

With built-in memory, your AI chatbot should learn to answer your customer questions on its own without frequent re-training. As customer chat with the bot more, it continuously analyze the conversation and learn to improve its response.

I would like to invite you to give it a try with free account to see it for yourself if it can help you grow your business and save cost.

Feedback is appreciated in advance, I will read and consider every feedback and work harder to improve this product.

thanks
I didn’t use a security camera; I built a sky camera. It has a 140 degree fisheye lens with a Pi HQ camera (I might replace the camera). Built a waterproof case and it’s been living on my roof. It recorded the aurora over the SF/Bay Area. Not super spectacular but I was exited. https://youtube.com/watch?v=Pkks7PWzpSM
This is very interesting. Some lines which I remember from movies, I rarely do so because of the words. It's almost always because of the way it was delivered and the emotion or "vibe" that it put out.
Eh, there was also the episode where Tesla introduced a battery swapping scheme only to claim higher green tax credits, without actually rolling it out. It's a deceptive company.
If you run the above docker command, which is directly from the docs, it copies everything inside of your current working directory. Not just PHP files.
Government EV subsidies in China are being tapered off rapidly, they don't need them any more.

https://dialogue.earth/en/business/life-after-subsidies-for-...
Why would her having a smartphone lead to an expectation of location sharing? I completely expect my five year old son to have the freedom to just not have his future gadgets on him if he so prefers when he gets to the age that a smartphone is unavoidable, and I certainly don't expect him to let us track him.

Hopefully the age where a smartphone becomes a requirement to not be marked as a social outcast will gradually rise again.
What are the good solutions in this space? Vector databases I mean. Mostly for semantic search across various texts.

I have a few projects I'd like to work on. For typical web projects, I have a "go to" stack and I'd like to add something sensible for vector based search to that.
PHP 6 was never released.
You have a pretty good visa situation, you can move if you don't like it.
Parquet the most popular columnar format. (owing to support in Spark and various other big data tools, as well as local tools like pandas, polars and duckdb)

It's technically not the very best format (ORC has some advantages), but it's so ubiquitous and good enough -- still far better than than CSV or the next best competing format. I have not heard of Carbon -- it sounds like an interesting niche format, hopefully it's gaining ground.

It's the VHS, not the betamax.
When it's a duty that others have imposed on you, it becomes a form of oppression rather than free action. Instead of feeling good about helping everyone, you feel bad about being bossed around by everyone.

The "socially-enforced expectation" is the same. You know whether you're doing something altruistically for the common good, or whether you're doing it because if you don't others will try to shame you.
There are claims this is faster. It's not. I used it, together with other "alternative" runtimes which are just PHP command line interface long running scripts with some sort of task distribution balancer in front. Just like PHP-FPM is.

The apparent speedup comes from the fact it's not shared-nothing, meaning that objects from previous requests (and variables) are persisted and present in subsequent requests. This makes it work exactly like Node.js, removing the wonderful part of PHP which is that it automatically cleans up all the crap devs created and creates clean slate when next request is to be executed.

All of these "alternative" runtimes are false positives, because they're quick for first few requests but get slower and slower for the subsequent ones. Then, the workers are killed and restarted (precisely what PHP-FPM does too).

Since there's no new engine behind executing PHP, the only way FrankenPHP (and others) can yield any performance is when they're benchmarked against misconfigured PHP-FPM (opcache off, JIT off, persistent connections off).

It's not my cup of tea. I like that there are attempts at doing <something> but turning PHP execution model into Node.js execution model isn't the way to go.

I find it cheaper to throw a few bucks at stronger hardware compared to risking accurate execution to become flaky because shared-nothing is now unavailable.
An example of what seems to be a reasonable usecase for UDP proxy is Quilkin[1] from Google.
Made for hosting game servers on Kubernetes, and supports session auth, routing, monitoring, and various other features, some of them using prefix bits in UDP packages.

Also used for DOS protection without the traffic hitting the server.

Not sure how usable it is but Google actually has a lot of open-source stuff for game hosting on kubernetes with agones + openmatch + quilkin, I am somewhat tempted to play with them at some point.

[1] https://github.com/googleforgames/quilkin
The PHP built-in server is explicitly stated not for production use, and is intended for development purposes only.

See the warning at the top of the page: https://www.php.net/manual/en/features.commandline.webserver...

Not sure it's even fair to consider it for comparison in this context.
On a properly working system, this should generally not happen, but there are sooo many things that could be going wrong.

I'd first try on a different WiFi that has both a different router and ISP. That should narrow down where you have to search for the problem.
This is a great example that’s actually not a good thing. The lack of paranoia is going to allow many others to track you for their own purposes like companies and governments and just allow privacy erosion to happen passively.

“You have nothing to fear if you have nothing to hide” os pretty similar to “you have nothing to fear if someone else chooses not to look”
Before shutting it down, let the world know
But I had to pay for access to this marketplace, only to have an arbitrary barrier put in place that can be paid to pass..

Isn't the whole review system supposed to promote good quality content?

This change, if genuinely implemented to try and improve app quality, actually only frustrates new developers that are trying to join the ecosystem.

20 people is quite a lot! After getting all my friends and family that use Android testing it, I still needed 10+ more 'testers'.