HNHacker News
TopNewBestAskShowJobs

gaploid

41 karma · joined May 10, 2016

submissionscomments
gaploid··on Show HN: The impact that made the Moon, 262k particles in a browser tab
;)
gaploid··on Show HN: The impact that made the Moon, 262k particles in a browser tab
Thanks
gaploid··on Show HN: The impact that made the Moon, 262k particles in a browser tab
There is a theory that moon was constructed from Thea planet impact with young Earth. Thats a simulation of that episode of Solar system:)
gaploid··on Show HN: The impact that made the Moon, 262k particles in a browser tab
I will take a look on Safari, thanks for the feedback.
gaploid··on Show HN: Web Tool to Create a Universal Database MCP Server
Wow, really easy to create server. For how long is it stayed active?
gaploid··on Show HN: Nuanced – Help AI understand code structure, not just text
Hmm, probably its better to use yaml or something more token optimized. That output graph for large projects could eat a lot of tokens, I guess.
gaploid··on Show HN: Open-Source Tool to Generate AI-Agent APIs from Your Database
It was a fun to participate in development. Looking forward what people will say:)
gaploid··on [dead]
Hey I'm Victor! My team and I built CentralMind Getaway just recently, an open-source tool that auto-generates secure and AI-optimized APIs from structured data. It's for those who don't want to expose direct SQL access to their databases to AI-Agents and spend time building these APIs manually.

What it does: - Auto-generates APIs from your database schema & sample data using AI

- Filters out PII and sensitive data for compliance (GDPR, SOC 2, etc.)

- Optimized for AI with extra meta information for REST and MCP support

- Works with PostgreSQL, MySQL, ClickHouse, Snowflake, BiqQuery

- Bunch of plugins: Telemetry, Auth, Caching, RLS and others

- Deployable via binary, Docker, or Helm

Check it out and please share your thoughts!

- Interactive Demo (GitHub needed): https://codespaces.new/centralmind/sample_databases

- GitHub: https://github.com/centralmind/gateway

- Docs: https://docs.centralmind.ai/

- Video: https://youtu.be/5xumga3QjmA

gaploid··on How I write code using Cursor
Using ChatGPT and AI assistants over the past year, here are my best use cases:

- Generating wrappers and simple CRUD APIs on top of database tables, provided only with a DDL of the tables.

- Optimizing SQL queries and schemas, especially for less familiar SQL dialects—extremely effective.

- Generating Swagger comments for API methods. Joyness

- Re-creating classes or components based on similar classes, especially with Next.js, where the component mechanics often make this necessary.

- Creating utility methods for data conversion or mapping between different formats or structures.

- Assisting with CSS and the intricacies of HTML for styling.

- GPT4 o1 is significantly better at handling more complex scenarios in creation and refactoring.

Current challenges based on my experience:

- LLM lacks critical thinking; they tend to accommodate the user’s input even if the question is flawed or lacks a valid answer.

- There’s a substantial lack of context in most cases. LLMs should integrate deeper with data sampling capabilities or, ideally, support real-time debugging context.

- Challenging to use in large projects due to limited awareness of project structure and dependencies.

gaploid··on [dead]
Hey Hey,

We're curious about your thoughts on Snowflake and the idea of an open-source alternative. Developing such a solution would require significant resources, but there might be an existing in-house project somewhere that could be open-sourced, who knows.

Could you spare a few minutes to fill out a short 10-question survey and share your experiences and insights about Snowflake? As a thank you, we have a few $50 Amazon gift cards that we will randomly share with those who complete the survey.

Thanks in advance

gaploid··on Show HN: Unlocking Insights Hidden in Data Charts with GPT-4
As per next steps: We plan to test multimodal ChatGPT with image data, perhaps passing the full screenshot of a dashboard with different charts, to improve the model's contextual understanding. As the main constraint when implementing with raw data is the prompt length, data displayed in a visual format may be more condensed and compact.
gaploid··on How I migrated to Clickhouse and speedup my backend 7x and decrease cost by 6x
The article about of importance to use the right technology for your workloads and think for 1-2 years further of your project
gaploid··on ClickHouse Cloud is now in Public Beta
Why are you using 'threads' instead of vcpus or aws instances like it was for other benchmarks? Thats really hard to compare and add suspicions here.
gaploid··on Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)
Could you share a list of them?
gaploid··on Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)
We built a Managed ClickHouse service to help exactly these difficulties with that technology. We are handling sharding, clustering, zookeeper, patching, updates without downtime, and Hybrid storage based on S3. https://double.cloud
gaploid··on [dead]
Great question! 1. We tried to build a platform covering end-to-end analytics scenarios with core services based on open-source, and Kafka is an essential block in such solutions. 2. Using them on the same platform eliminates things like traffic between accounts and traffic between AZs and solves security concerns. 3. We are also adding things that help integrate each of these blocks and help users to start using open-source technologies faster.
gaploid··on [dead]
CDC is our secrete and currently free feature:)
gaploid··on [dead]
Sure, we built it with "bells and whistles": Tools for visualization with native support for ClickHouse, lightweight ETL service, and many other things like backups, monitoring, and logs. We even support ClickHouse over S3 when data could be decoupled from computing to S3, giving a performance of Clickhouse and cost of S3 storage.
gaploid··on [dead]
Hi everyone, I'm Victor and Product Lead at https://double.cloud if you have any questions feel free to fire them to me.
gaploid··on YDB – An open-source Distributed SQL Database
That's something similar to DynamoDB and CosmosDB. I believe the workaround is to have paging on client side to fetch all results.
gaploid··on YDB – An open-source Distributed SQL Database
it seems not. they have compatibility for querying external PG dbs (YQL query engine), I thing that's the reason for that.
gaploid··on YDB – An open-source Distributed SQL Database
I believe that something like AZure CosmosDB, AWS Aurora/DynamoDB but open-sourced, which is great.
gaploid··on YDB – An open-source Distributed SQL Database
ClickHouse is OLAP (analytics), this one is OLTP (transactional)
gaploid··on YDB – An open-source Distributed SQL Database
I believe cloud revenue in Yandex structure is quite low and main business in search/ads
gaploid··on Show HN: EC2 Spot Instances Advisor 2.0. Compare Pricing, specs and etc
Haha, don't know yet. It seems that could be quite beneficial if I will add forecasting as a paid feature. But until then it would be as public tool.
gaploid··on Show HN: EC2 Spot Instances Advisor 2.0. Compare Pricing, specs and etc
Created a tool - one-page view about for EC2 Spot instances. Compare pricing between regions(10-300% diff), pricing in time, specs and etc.
gaploid··on Show HN: Analyzing 1000s of HD twitch videos to track players in Apex Legends
Yeah:) feel free to ask questions
gaploid··on Show HN: Analyzing 1000s of HD twitch videos to track players in Apex Legends
Here you go https://imonstream.com/home/search?nickname=Xenovert&game=3 but try that on pc. Twitch player on phone is buggy.
gaploid··on An easy tool to find most valuable and cheapest VM on Azure
Nice one! Like the column "best region" in VMs table.