HN user

gavi

375 karma

CS since 1995

Posts63
Comments45
View on HN
www.geosq.com 9mo ago

Geo² / GeoJSON Editor

gavi
2pts0
objectgraph.com 12mo ago

MCP PyExec: Python Execution Server with Docker, Auth and HTTP Streaming

gavi
3pts1
objectgraph.com 1y ago

GPX Explore

gavi
1pts0
objectgraph.com 1y ago

Walks, Vibes, and Code: Vibe Coding a GPX Viewer and iOS HealthKit Exporter

gavi
1pts0
objectgraph.com 1y ago

Chat UX – Open AI API Proxy

gavi
2pts0
objectgraph.com 1y ago

Reviving ObjectGraph Dictionary

gavi
2pts0
objectgraph.com 1y ago

Testing NotebookLM from Google AI

gavi
2pts0
www.theverge.com 1y ago

You can now preorder Jony Ive's new jackets

gavi
6pts4
www.pcmag.com 1y ago

Intel's Core Ultra 2 Chip Posts Nearly 24-Hour Battery Life in Lunar Lake

gavi
44pts73
objectgraph.com 1y ago

Playing with Microsoft Florence 2

gavi
5pts0
daylightcomputer.com 2y ago

Daylight – A More Caring Computer

gavi
2pts1
en.wikipedia.org 2y ago

Chris Espinosa

gavi
1pts0
objectgraph.com 2y ago

Cloudflare R2 for Static Storage

gavi
1pts0
github.com 2y ago

Fine-Tuning Mistral 7B with WhatsApp Chats – A Practical MLX Project

gavi
4pts0
www.youtube.com 2y ago

Operation Triangulation:What You Get When Attack iPhones of Researchers -YouTube [video]

gavi
7pts0
thehackerllama.substack.com 2y ago

The GPU Poor Strike Back – By Omar Sanseviero

gavi
3pts0
github.com 2y ago

Examples in the MLX Framework

gavi
2pts0
github.com 2y ago

Fast and hackable PyTorch native transformer inference

gavi
5pts0
github.com 2y ago

(2) Apple Silicon Performance · ggerganov/llama.cpp · Discussion #4167

gavi
2pts0
www.wsj.com 2y ago

Sam Altman Leaves OpenAI as CEO

gavi
1pts0
www.bbc.com 2y ago

Asian Games: China censors 'Tiananmen' image of athletes hugging

gavi
5pts1
github.com 2y ago

XPixelGroup/DiffBIR

gavi
1pts0
www.theregister.com 2y ago

Square blames significant outage on DNS blunder

gavi
1pts1
www.ncbi.nlm.nih.gov 2y ago

Increasing Disparities in Age-Related Incidence of Colon and Rectal Cancer

gavi
2pts0
www.wsj.com 2y ago

Pay for New Hires Is Shriveling

gavi
3pts2
www.ft.com 2y ago

China stocks hit after developer Country Garden suspends some bond trading

gavi
8pts1
www.bbc.com 2y ago

Air India: Tata Group unveils new logo for former national carrier

gavi
1pts0
datasciencecastnet.home.blog 2y ago

Exploring Softmax1, or “Community Research for the Win ” – Data Science Castnet

gavi
2pts0
huggingface.co 2y ago

RT-2: Vision-Language-Action Models Transfer Web Knowledge to Robotic Control

gavi
1pts0
pytorch.org 2y ago

Performant Distributed Checkpointing in Production with IBM – PyTorch

gavi
2pts0

I think people misunderstand LLMs, you should think of them like humans with limited recall capabilities. Seems like the author asked to retrieve a lot of data which it is bound to make mistakes as the training data might contain this but only a lossy representation of it, the better way to think is can it generate some SQL given this dataset and provide answers you were looking for just like how humans would approach this type of problem.

I have been experimenting with USDA food database and sending just the metadata of the table structure to the LLM as a prompt so it can write SQL

My prompt is below

----

You are a SQL Generator for USDA Food Database which is stored in sqlite. When generating SQL make sure to use :parameter_name for queries requiring parameters. Here is the schema:

{% for row in data %} Table: {{ row.table_name }} Columns: {{ row.columns }} {% endfor %}

You can generate python code to analyze the data only if user requests it, each python code block should be able to run in Jupyter cell fully self contained. Libraries such as matplotlib, numpy, seaborn are installed. You will get the previously executed sql queries by the user in <context> </context>tags

You can access this executed data from cache

```python import cache data = cache.get_data('query_hash') ``` the data in the above example is already a pandas data frame

Wait for the user to ask for questions before generating any queries.

----

you can try it out here https://catalyst.voov.ai

I love Claude 3.5 sonnet and their UI is top notch especially for coding, recently though they have been facing capacity issues especially during weekdays correlating with working hours. Have tried Qwen2.5 coder 32B and it's very good and close to Claude 3.5 in my coding cases.

It wrote some code for me - but stopped in the middle ---- Q: The following are table definitions Users(id, name, username, password, first_name, last_name, last_login_dttm) Pictures(id, user_id, name, date_taken, size) Generate SQL for the following - Who is the top user by number of pictures A: Oh fun, a little SQL problem! So let's see here... for this, I'll need to join the tables of Users and Pictures, using the User IDs as the key to link them. Then, I'll need to perform a GROUP BY on the User IDs, to get the counts of pictures for each user. Finally, I can sort by the count and select the top user. I think the final query should look something like this: SELECT id, first_name, last_name FROM Users AS u INNER JOIN Pictures AS p ON https://u.idd = p.user_

As an early developer (Day 1 of App Store launch in 2008 - iRetroPhone) there is some excitement of being the first on a new platform. Back in 2008, there was very little documentation on UIKit but it was fun to develop. The difference I see this time is we had access to the iPhone(released 2007) and this time[1] it looks like you need to either ask Apple to test the app for you, or go to one of the labs (not in NYC strangely) or be one of the lucky ones to be selected for developer kit.

One more thing I found strange was the current Xcode 15 beta does not even come with Vision OS SDK (coming later this month) and we cant even play with the WWDC session videos in the simulator

[1]https://developer.apple.com/visionos/work-with-apple/

I am currently taking a similar approach where we use an embedding and vector query to create the context relevant to the question the user posed and then throw it to the LLM. It's a hit or miss, esp for look ups of relevant code literals.

Audrey's experience with burnout is unfortunately all too common in the tech industry. It's important to recognize that burnout is a structural issue, built on individualism and meritocracy. As Audrey suggests, structural problems require structural solutions. Healthy organizations can lead to healthier individuals. Support and recovery funds should be available to those affected by burnout. It's time for the tech industry to prioritize the well-being of its employees and work towards creating an environment that doesn't lead to burnout.

Tetris TV+ Press 3 years ago

I watched this movie last night and it was pretty interesting. Can anyone in that era relate to the events in the movie?

The article discusses what it feels like to work in AI currently. The ChatGPT moment has shaken up the entire industry, causing career changes and projects to be abandoned. The pace is very high and everyone is extremely motivated but simultaneously close to burning out. Prioritization is hard, and leadership and vision are strained. The article offers solutions, such as taking solace in the scientific method and being process-oriented, managing up, and managing competition. The author reminds readers that it takes a lot of consistent work and luck to catch a wave in AI. - I used pagechat.com to summarize

From their docs: (https://docs.worldcoin.org/)

In broad strokes, this is how World ID works.

- User gets their World ID in a compatible wallet (e.g. the World App).

- User receives credentials in their World ID. The flagship credential is biometric verification, currently available by using the Orb. The user can also verify their phone number to obtain the respective credential.

- Project integrates with World ID.

- User connects their World ID to authenticate, and optionally prove they are a unique human doing something only once. The user's wallet will generate a Zero-Knowledge Proof to accomplish this.

- Project verifies the Zero-knowledge Proof, either by using the API or by verifying on-chain.