Hacker News

Article URL: https://devblogs.microsoft.com/oldnewthing/20241119-00/?p=110543

Comments URL: https://news.ycombinator.com/item?id=42190699

Points: 5

# Comments: 0

Article URL: https://twitter.com/lindayaX/status/1858953689450639635

Comments URL: https://news.ycombinator.com/item?id=42190664

Points: 3

# Comments: 3

Article URL: https://en.wikipedia.org/wiki/-30-

Comments URL: https://news.ycombinator.com/item?id=42190654

Points: 1

# Comments: 0

Article URL: https://emschwartz.me/understanding-the-bm25-full-text-search-algorithm/

Comments URL: https://news.ycombinator.com/item?id=42190650

Points: 4

# Comments: 0

Article URL: https://9to5mac.com/2024/11/19/microsoft-mac-mini-desktop-pc/

Comments URL: https://news.ycombinator.com/item?id=42190648

Points: 1

# Comments: 1

Article URL: https://izzys.casa/2024/11/on-safe-cxx/

Comments URL: https://news.ycombinator.com/item?id=42190647

Points: 6

# Comments: 0

Article URL: https://github.com/GH-DOOM/DOOM64

Comments URL: https://news.ycombinator.com/item?id=42190632

Points: 2

# Comments: 0

Article URL: https://www.bloomberg.com/news/newsletters/2024-11-17/paramount-boss-on-gladiator-ii-scary-sequels-and-wicked-showdown

Comments URL: https://news.ycombinator.com/item?id=42190548

Points: 1

# Comments: 0

Article URL: https://www.techdirt.com/2024/11/18/epic-allows-internet-archive-to-distribute-for-free-unreal-unreal-tournament-forever/

Comments URL: https://news.ycombinator.com/item?id=42190541

Points: 1

# Comments: 0

Article URL: https://ericswpark.com/blog/2024/2024-11-19-the-esc-key-bug-in-games-with-cjk-imes/

Comments URL: https://news.ycombinator.com/item?id=42190489

Points: 1

# Comments: 0

There are 5 important factores to keep in mind when you are analysing a new backlink collaboration.

Keep in mind that a lot of these factors are already covered on your RankChase matches!

1- Domain Authority (DA) It's important to aim for a website with a similar DA as yours or higher. Websites with a much lower DA compared to your website might have a lower to zero impact in your domain authority.

You can use Ahrefs backlink checker to find out the DA of a website.

2- Website Niche It's important that the website that will be linking to yours is in a similar industry as your website.

For example, for Podsqueeze, since we work in the podcast industry, websites that are also tools for podcasters or podcasts are ideal backlinks.

3- Backlinks/Linking Websites Ratio Try to avoid websites in the business of selling backlinks (backlink farms). You can identify such farms by comparing the number of links that they have pointing to them vs how many links they are pointing to.

If one website is pointing to much more websites than the websites that are pointing to them, then is probably best to stay away.

Ahrefs backlink checker will also show you this ratio.

4- Traffic The more traffic a website has, the higher the chances of your backlink to be quickly indexed by google and of you actually getting traffic coming from that website.

Plus, having traffic is a good indicator of a legit website

We can use tools like @Similarweb to get an estimation of their traffic.

5- Avoid Artificially DAs Some websites will artificially increase their DAs by getting multiple backlinks from a few high DA link farms.

On Ahrefs domain checker you can check what are their main backlinks. Make sure to analyse them too and figure out if they are legit.

The cool thing about using RankChase is that we do the heavy lifting for you:

1- We only match you with websites with similar or higher DA and in a similar niche!

2- We show you all the relevant metrics to help you decide (spam score, DA, niche, etc...)

3- Your matches are legit websites with businesses that are not centred in selling backlinks.

Comments URL: https://news.ycombinator.com/item?id=42190487

Points: 1

# Comments: 0

Article URL: https://www.bbc.com/travel/article/20241115-how-railroads-inspired-the-creation-of-time-zones

Comments URL: https://news.ycombinator.com/item?id=42190473

Points: 1

# Comments: 0

Article URL: https://archive.vector.org.uk/art10010830

Comments URL: https://news.ycombinator.com/item?id=42190471

Points: 1

# Comments: 1

Article URL: https://chatgpt.com/share/673d5043-cf90-800e-98f0-1ef4963c6baf

Comments URL: https://news.ycombinator.com/item?id=42190468

Points: 1

# Comments: 0

Article URL: https://www.bbc.com/news/articles/cy4g193qezno

Comments URL: https://news.ycombinator.com/item?id=42190456

Points: 1

# Comments: 0

Demo: http://www.sqltab.com/static/average_earning.gif

Try it here: https://www.sqltab.com/demo

Main features:

- AI-powered SQL assistant. Allows (one-click) execution and undo/redo of SQL generated by the AI.

- GUI to rename, remove, and reorder columns in SQLite tables.

- Undo/redo support using SQLite's savepoints [1].

- JSON data expansion: https://www.sqltab.com/static/json_expand.gif

- The pivot table extension [2] is loaded and available for use. The AI is also aware of it.

Privacy & Data:

- Databases are stored locally in the browser using OPFS.

- Database schema is sent to OpenAI as part of the chat session's context window. If the chat session contains results of data querying, then that will also be sent to OpenAI with the next message.

Tech stack:

- WASM build of SQLite (using a custom fork of the official repo [3]).

- React + Mantine for the UI.

- esbuild to build the frontend (invoked from Go). So much faster than the alternatives.

- Hosted on Cloudflare Pages, deployed via wrangler CLI.

- Single API endpoint just to proxy OpenAI calls in order to hide my API key. Hosted on Cloudflare Pages Functions (very practical but only for simple things).

Technical notes:

- The entire application is a static website except for the OpenAI proxy. Planning to support user-supplied API keys to (optionally) get rid of this.

- OPFS storage comes with some limitations (e.g., no incognito mode on mobile, same DB can't be opened in multiple tabs).

- gpt-4o is used for the LLM. Might switch to gpt-4o-mini to save costs.

Why not DuckDB?

- I got some out-of-memory errors when expanding JSON data. SQLite worked fine on the same data.

- No OPFS support yet. PRs have been pending for a year now.

If you want to reset the demo, just delete the IMDB.sqlite database (disk icon in the top-left corner -> "Delete DB") and load the demo URL again in the browser.

Please let me know if you have ideas about how to make this more useful.

[1] https://www.sqlite.org/lang_savepoint.html

[2] https://github.com/jakethaw/pivot_vtab

[3] https://sqlite.org/wasm/doc/trunk/about.md

Comments URL: https://news.ycombinator.com/item?id=42190445

Points: 1

# Comments: 0

Article URL: https://www.wsj.com/science/space-astronomy/nasa-to-assign-delivery-missions-to-spacex-blue-origin-as-part-of-artemis-lunar-exploration-campaign-70bc94d1

Comments URL: https://news.ycombinator.com/item?id=42190443

Points: 1

# Comments: 0

Article URL: https://www.bbc.com/future/article/20241118-how-new-yorkers-are-reclaiming-their-harbours-heritage

Comments URL: https://news.ycombinator.com/item?id=42190436

Points: 2

# Comments: 0

Article URL: https://www.servethehome.com/lenovo-has-a-cxl-memory-monster-astera-labs-intel-xeon/

Comments URL: https://news.ycombinator.com/item?id=42190434

Points: 1

# Comments: 0

Article URL: https://apnews.com/article/arthur-frommer-died-7293814296854079a3a10f05d02faf44

Comments URL: https://news.ycombinator.com/item?id=42190427

Points: 1

# Comments: 1