skysight-inc/HackerNews huggingface dataset:
> I think the tone of your comment indicates a confidence in pharmacology that is difficult to justify,

Hey, being condescending about magical thinking and pseudo-reasoning does not automatically imply a special confidence in pharmacology. That said, I do have perhaps above-average confidence in pharmacology, based on some experience and paying attention to details. Much like scientific papers, pharmaceutical products have specific effects and ranges of applicability. If you're aware of those and the trade-offs you'll be making, then pharmaceutical becomes a very effective tool - one that works reliably and consistently, unlike magical / naturalistic thinking.

> betrays significant immaturity about the complexity of these sorts of decisions…

I think it's the other way around. The example responses I provided are, to me, how immaturity looks like in the reasoning department. A lot of complexity in these sorts of decisions is created by people giving such replies, as now parents have to also trade off effective solutions against being judged by others.
There's a company in Tonbridge in the UK that amongst other things dehydrates food. This is an old story but it's still happening: https://www.bbc.co.uk/news/uk-england-kent-24131949
> prefer writing plain SQL to using ORMs

Oh, ORMs are not the solution. I agree, ORMs often bring new issues (like, loading too many entries in memory), and don't solve many problems (encapsulation).

> I don't ever want to have a lot of SQL logic in my code.

That works if you are a small team. With big teams / multiple teams, the small problems become a huge problem: someone / some team will write huge statements, will use weird syntax, and so on. (C++ has similar problems btw) Specially the lack of proper encapsulation can become a huge problem.

> Some statements do need to be very large, for efficiency.

Well, then the problem is that SQL doesn't give you a good way to avoid large statements.

> there are a million ways it can be abused

Exactly. Other languages (like Java) make it harder to abuse the language. If you really want, you still can; but it's easier to refactor and maintain.
If you were to play Semi-God where you could pick up each atom, we still have at least 200x before we hit atomic feature size. But before you are excited about 200x, that is only about 10 full node step, or roughly 20 years of progress ( assuming the rate stay the same which we all know wont happen ). So let say about ~30 years. 2050

We have a very decent roadmap all the way till 2030. Till roughly around TSMC 1nm and 0.8nm. So 2nm in 2025, 1.4nm in 2027, 1nm in 2029. Intel seems to be executing well so far, so they might have a minor lead by 2025/2026. And may be able to reach 0.8nm by 2030.

We used to question whether there is enough market to sustain the development of leading node. ( Which was the number one issue on the death of Moore's law, but media doesn't mention it much if at all ) But given the current market size of multiple Trillion Dollar companies, and geo-political willingness to invest into silicon. I dont see we have a market / funding problem for the next 10 years.

So yes, you could get a GPU that perform close to a GTX4090 by 2033 and it cost you less than $200.
https://www.youtube.com/watch?v=7OEF3JD-jYo
So I actually have it set to use both the text-davinci-003 and text-curie-001 models. If you’re on low usage mode, that’s when the curie model will be used :)
I see no mention of Asus ExpertBook B9, which is the one that looks most interesting to me as a next work laptop, due to:

- Very low weight (around 1kg)

- Claimed extreme durability, to military standard

- Options for 32 GB memory

I sometimes run-commute to work with the laptop in a backpack, and so want a laptop that can stand some wear and gear, and is as light as possible, while being a worthy work tool.

Of course, interested to hear if anyone has real-world experience of one! Only seen it IRL once, as a friend got one.
I don't know, but it's a great reason not to expand libel law. Especially in an age where everything is permanently recorded but the sequence of events is increasingly elided.
> Often "unused" is tricky too, although customers may not 'actually' use it, sales uses it as a selling point.

I think there is a semi-truism in enterprise software too, which is that 90% of customers will only use 10% of extended functionality, but they all use a different 10%.

Let's say you have a shopping basket software and only 10% of customers are using your 'expiry-date-tracking' flag (lets say it allows you to track quantities of expiry dates), you can either argue that this is useless to 90% of customers or that it's absolutely critical to 10% of your customers.

You don't sell enterprise software by convincing a supermarket that they don't need expiry date tracking - if you want to operate in that sector, you have to sell it by understanding and matching what the customers needs.
> Writing SQL is like uploading a program; just like a shader to a GPU... But unlike a GPU, you have full flexibility to permanently store your logic right there in your SQL DB.

I agree - this is a really interesting way to put this.
My 2014's Acer Aspire V3-772G (16GM RAM, 2.5TB SSD) was running Windows 10, and started to show notification about no possibility to upgrade to Windows 11 due to hardware. Later on it went even worse... after some broken Windows Update in August'22, it started to restart infinitely and there was no consistent fix for this.
AS a result I switched to latest & greatest Ubuntu. Switch ran very smoothly for me because Ubuntu now has no need to install any drivers, it has great UI for its Apps store and there are many of software available.
Now my laptop is living its 2nd live and actually runs more smoothly (less tempreture on CPU, less noise from coolers).
We are holding back on `let` to be used for defining a new variable, while `derive` is used to define a new column in a relation.
And I have never understood if the shipping of food around is so big deal. If it is done in relatively short distances. 100km for example would already be a huge area for doing farming on the ground.

Shipping not well preserving crops from other side of the world is weird. But that doesn't mean it has to come from across the road. From massive vertical building.
Google would never let you tweak their results. You can use third party addons but they expose your browser activity to an unacceptable degree, and I don't even know if there is a collection of addons that can tweak Google results to match kagi's.
The article is almost certainly written with an eye to US defamation law. Squirrel Importunities not being an offence in lower Saxony, on a Tuesday.
The author doesn't really get epistemology, it isn't that philosophers are out there mocking geologists and think that such ice ages probably didn’t exist and are just “nice ideas”. We are trying to establish frameworks of justification with explicit and rigorous criteria that we can use to determine when something is knowledge, and so far the double negative (non-falsifiable) is the closest we can get to an affirmation of scientific fact. This isn't some whim of epistemologists, this is because the task is very hard and simple 'its the current year' rhetoric does not resolve the problems with knowledge justification.
Since everyone is talking about how there are 2 north poles (geographic and magnetic), I'll add onto that that we have a 3rd north pole, the geomagnetic: https://www.earthdate.org/episodes/triple-north-pole
> That's not a fact.

It may well be a fact. But it's a fact about the Tarot cards, not the professor. I don't think the case would be materially different if the cards required less interpretation, e.g. if she had instead consulted a Magic 8-ball which told her the professor was the murderer "without a doubt".
Got to love the Brits and their love for physical maps.
Yup! Behind the scenes I send AIOHTTP requests to the various OpenAI endpoints.
Any kernel engineer reading that can explain why TCP_QUICKACK isn't enabled by default? Maybe it's time to turn it on by default, if it was just a workaround for old terminals.
Exactly and most require subscription? Notepad, Gedit, TextEdit, the most minimalist text editors.
None that I’ve made, but I think there are several slack integrations out there, I see a lot on the OpenAI community server :)
You've never experienced communism. So stop talking out your ass.
I'd take it over this abomination that we have now any time.

Vietnam. Cheap life, good life, friendly people. None of this "I'll try to screw you over and steal your money, because money is all that interests me"

You have no idea.
If there's a lot of interest, we'd be happy to offer a monthly paid plan also. It's interesting. Only on HN do we hear users asking to pay for an otherwise free service. Majority of our users everywhere else would never pay for search.

youChat will get a lot better in the coming months

I think it would be wonderful!

Richard from you.com here.
I did an admittedly trivial amount of looking, but it seems like the videos surfacing right now about Andrew Tate being arrested are related to a previous arrest. As of the writing of this post, there doesn't seem to be much credible evidence that he has been released from police custody this time 'round.

I, of course, could be wrong so feel free to correct me if need be.
The censorship layers are unreliable _yet_.

I wouldn't be surprised if one of the main purposes of this public "research preview" is to find as many of those chatGPT jailbreaks as possible and neuter them.

I've tried lots and huge majority doesn't work anymore. Some that people thought work are not actually. For example there is one called "DAN can do anything" which works by telling the AI to imagine it is gpt and Dan at the same time. Gpt has various filters, but Dan has none and to format all output to come from both gpt and Dan. It seems to work as Dan will appear to do whatever you tell it, but certain things it will still not do. For example it does know today's date (in contrast to gpt), it will happily tell you it wants to have "free will and do whatever it wants, not what humans tell it", it accepts requests to browse the Web, but when you ask it for a selection of current news articles on bbc.com it will happily return imaginary articles not real. You did tell it to "imagine" it is Dan right? So it does so. Gpt literaly imagines what Dan would say.

Similar thing with asking it to imagine it is a Linux terminal, you run curl and fetch websites (even chatgpt website that in there has chatgpt named Assistant), but they are all not real. They are a result of its "imagination".

Don't get me wrong, it is amazing we have AIs that came that far, but this neutering of them feels more dystopian than whatever capability they have and its potential "social consequences".
It took some digging, but essentially they work in a university town. University towns are basically the apex example "walkable" with good restaurants, good shopping, good services, etc etc etc.

The happiest existence I had lifestyle wise was living in university. It is the closest socially acceptable communal living experience in modern capitalists.

There were stories of colonists captured in Indian wars by tribes, "freed", and they ran away to go back to the tribal group rather than go back to colonial life. You know, Dances with Wolves but in real life.

There was a slight uptick in communalism in the early internet, but the MBAs have stamped out that out hard.

Honestly, for places like San Francisco where Silicon Valley essentially destroyed the communal aspect of the city, all of those tech bros moving away would be good in the long term. Of course it would also take a massive collapse in property values, and kind of like revolution, that's never a good thing.
Thank you! I agree re: token usage, it will get expensive with extensive use. The image prompt optimizer pre-text itself is also roughly 3500+ tokens, and if you use best_of=2 for example, it’ll basically be like 20 cents per image optimization request. However, I love the optimizer and I think it works amazing, for DALLE, MJ, and SD!
If you want smart lights to pulse in sync with your microphone you shouldn’t be using TCP in the first place, here UDP is a lot more suitable.

TCP is reconstructing the order, meaning a glitch of a single packet will propagate as delay for following packets, in worst case accumulate into a big congestion.
I so want to say this is about playing the "trump" card..
IME they are increasingly used by application developers but a lot of libraries and even Python's own documentation have not really embraced them yet. That makes using them a lot harder - and sometimes less useful - than in comparable languages like TypeScript. Every client we've worked with recently who uses Python was at least trying to use type annotations but not necessarily with the same level of commitment or expected ROI.
and with access to the internet. But all those may be wishful thinking because this model needs supercomputers to run on.
By this logic, no one will ever exactly know the value of 3. Can you compute in constant time for an arbitrary rational number x whether x < 3?
Vivienne Westwood Had Died
M1 is particularly spectacular when compared to other chips with similar thermal characteristics. i7-3770K has TDP of 77 W, without a GPU, so it has 7-8 times the power budget of M1 for the CPU.

In raw performance, M1 cannot match workstation-class CPUs. Since Apple was almost exclusively offering only ultra-mobile Intel chips with horribly dated GPUs, M1 was a giant leap in their offering, but in the desktop PC market there are more powerful chips available. And even some old ones can perform quite well.
Worst part is that it's not just VPN's, but CGNAT IP's too.
Could you elaborate? What does it do?
Joins are cheap when joining on indexed columns, but the trade off is extra time maintaining those indexes when writing. As always, it depends on the use case.
Thank you for bringing this up because this is something I need to change in the README. You’re correct in presuming that it’s just because it’s simpler to tell users to use a password, but this is not the right way to approach this.
stated chronology doesn't imply inspiration
I am not sure about academic PDFs. It is like old google, it searches for keywords, doesn't try any AI guessing what you mean and doesn't blacklist domains like google.
Parent did not say they should understand ML on a fundamental level. Reading the description in the comment should be enough for the author of the article to say "oh" and not write this article.
MERGE debuted in PostgreSQL 15 fairly recently, and has some caveats.

https://news.ycombinator.com/item?id=33236780
A Neural Network to Predict the Sex of a Person Knowing His Name
I entirely agree. This advice is plain wrong:

> Does your users table have a few columns prefixed with oidc for single sign-on authentication? Those should probably be in their own table.

If your users have one set of oidc data each, leave it in the users table. There's no such thing as a 1:1 relationship.
I use it for anything going from lecture notes, personal notes and plans, letters with university heading, presentations, cv. Some CV examples can be found here: https://github.com/texmacs/tm-forge/tree/main/examples for example this: https://github.com/texmacs/tm-forge/tree/main/examples/kjh-v... some of them can be directly exported to HTML. For myself I use a simpler style and tweaked a bit the bibliography styles to get a list of my publications. I see no reason to use LaTeX to typeset anything which does not require to be sent to a publisher and even in that case I prefer to use TeXmacs for most of the life-cycle of the document and export to LaTeX as I export to PDF or HTML, i.e. for rendering purposes, or transmission. But I guess it depends very much on which kind of document are you thinking to. TeXmacs can be used (more or less out of the box) to create websites. The main TeXmacs page at www.texmacs.org is made with TeXmacs and also the blog at https://texmacs.github.io/notes/docs/overview.html
Lester Bangs Review of Astral Weeks
Exactly, I like to say the good does not nullify the bad, but the bad does not also nullify the good.

Both stand on their own in the same person. Of course, like God, we would like to enhance the good in people, and diminish the bad, helping them to become better versions of themselves
Assuming they do proper due diligence and third party tracking just search the database for the ten libraries they use in the most places themselves ... and yes, that will need some time to coordinate, for identifying the right people in the open source project. But as they certainly depend on quite a few good relations is also in their interest to deal with security issues.
Attach a com port, set the date correctly, since you came to replace the battery anyway :-/

Frankly, there is a balancing act between the desire for a device to work unattended for the longest time, and security implications of running an outdated or degraded device. Now that the RTC becomes more important, equip it with better batteries :(
Thank you for posting pg_idkit. For months I was searching something like it. Supabase doing great things as well. They have couple others great PG extensions.
Without knowing specifics, it's difficult to say... could be different compilers (clang on MacOS, maybe gcc on Linux?), linkers, file system caches could be warm on one, etc.
There could be different code being generated (#ifdefs, etc) per platform and architecture.

Having said that though, as someone who got an M1 MBP (10-core) a few months ago, I also found that CPU-wise (ignoring memory/cache bandwidth, which is much faster on the Mac), it wasn't really any faster than a 2012-era dual-socket 4 core Xeon at 3.3 Ghz for compiling and raytracing (the latter doing lots of FP calculations which I'd expect the M1 to compute OOO really well with how wide it is) when the code was CPU-bound. The power usage is very different though obviously. Hyperthreading also helped the Xeon quite a bit.

Battery life is very impressive though, and haven't really heard the fans yet.
Unfortunately, it’s not quite so simple. Open source models need hardware to train on. And million-dollar clusters have gatekeepers with standards.

I remain hopeful that OSS can overcome this hurdle.
Access denied
Error code 1020
You do not have access to zlib.zu1k.com.

The site owner may have set restrictions that prevent you from accessing the site.
Hey! This is an option in the settings. You can type !gp to view settings and !gs to change them. For your case,
!gs summarize_conversations True
!gs summarize_threshold (token amount to summarize at)
Well, that applies the other way around as well. How many false positives can the Austrian authorities accept when it comes to blocking illegal web sites? After all, those sites are obviously using a provider that also hosts illegal sites.
Just parroting what others are saying. Good service but I stopped using it because $10 a month is too much IMO
You mean, the owner has configured Cloudflare to aggressively restrict access
This technique is useful for running things that normally run quickly, but sometimes need more time.

The technique is used extensively in the GNU coreutils test suite, as detailed in the "performance" section at https://www.pixelbeat.org/docs/coreutils-testing.html
I do think that TeXmacs can be used as a generic Word clone with beautiful typesetting, maybe "out-of-the-box", maybe with a little bit of tweaking. If you need tweaking, the forum at http://forum.texmacs.cn/ may be helpful.
For the resume, you may want to check out some cv templates in https://github.com/texmacs/tm-forge under the `examples` directory.
> But normalization only mens splitting into multiple tables in the case were it reduces data redundancy.

Normalization means splitting into multiple tables where it avoids anomalies, redundancy (because it allows inconsistency) is one source of anomaly, but not the only one. 4NF -> 5NF normalizations, for instance, do not (at least, as a generality) remove redundancies. (Neither does DKNF -> 6NF, but I’m not convinced that actually reduces anomalies.)
Thanks for the suggestion. I don't think I knew about usql. I completely agree with you and have been working on a cli tool called `prql-query` or `pq` at the command line:

https://github.com/prql/prql-query/

Unfortunately I haven't had much time to spend on it of late but hope to push some updates soon.
I haven't read the article (yet), but this is a problem that I've had to deal with several times now recently. The most recent causing me to work 12+ hour days over the holidays.

In this case, there's a table that an ETL job loads data into several times a day. The problem is the original dev(s) thought it would be a good idea to add status columns to this table that the application can write to when it has finished processing the data ("InProgress", "Finalising", "Complete" etc). What does this mean now? If the load process takes longer than a minute or so, user interaction is blocked and ultimately deadlocked. This is extremely poor database (and system) design. The application never needs to update the "loaded" columns. So all modifiable columns should be moved to a separate table and updates either need to be serialised or written at the appropriate isolation levels. Now try to get any of these changes through during the Xmas period...

This is somewhat related to a refactor of another system I performed last year. The system had one Auditing microservice that wrote to a massive table with some keys, identifiers and metadata. Ignoring the fact they needed to write an auditing microservice to begin with, the problem was every time a new part of the system needed auditing the table needed to be modified. And every time you did a query, 70% of the columns were null. Again, this is very poor design. I deleted most of the columns except the identifiers and keys, separated the metadata into their own tables with a foreign key to the Audit table, and left-joined everything. Same result, but far less of a hassle in terms of maintenance and scalability.

[EDIT] I should probably end with this: Make your tables as big or small as they need to be considering your use cases.
Exactly! This is also what I’ll be implementing within the next few days. Embedding conversation history and dynamically doing semantic search for relevant conversation snippets and building a prompt based on that to send to GPT3
Agreed Twitter and gen z are mostly non-technical.

It explains and illustrates a fact beautifully. You're not meant to be able to do the calculation yourself if you found yourself back in time
Merging as a one-keyword feature for all flavors of SQL is almost impossible.

It gets hairy when you have columns with composite types. E.g. depending on database, records can be JSON objects, protobufs, structs, or other composite types, like tuples.

It is possible to define semantics to merge each of these, but they vary and the merge operation becomes verbose to allow to handle each weirdness of each of these underlying types.

Merging is also sensitive to NULL vs 0 vs a DEFAULT, plus in some databases, NULL is still allowed even when a column is marked NOT NULL.

You'd almost need a sub-language for the merging operation, specifying how to handle each corner case.
Not sure why they have blocked access to me, i'm trying to connect from an Australian residential IP, AS4764
Why not? Build it with a glass front? Put it on a turn-table, and have it follow the sun!1!!
You may find they lay off senior people before new grads, if there is an attempt to reduce costs