The best Hacker News stories from Show from the past day
Latest posts:
Show HN: Serverless OLAP with Seafowl and GCP
Hello HN! I'm an engineer at Splitgraph and recently started learning Rust so I could make my first contribution to Seafowl [0], an early stage analytical database. Along the way I figured out a database hosting hack on GCP and wanted to share it with HN. It's a way to achieve "true" scale to zero database hosting that could be useful for certain side projects or spiky traffic situations.<p>A recurring problem I've faced with side projects is the need for Postgres, but no desire to deploy or maintain new instances. So when I learned GCP's "always free" tier includes serverless [1] I got curious to see if I could run a database.<p>While a lot of classic databases aren't usually a great fit for serverless, Seafowl separates compute, storage and catalog (catalog == a SQLite file of metadata). [2] Last month I was able to introduce GCS bucket compat to Seafowl, which enabled me to mount the catalog via gcsfuse (i.e. an adapter that allows attaching GCS buckets to local filesystems). Upshot: while FUSE does add HTTP requests to container startup, init time remains comparatively quick, even cold starts, because fetching is limited to the single catalog SQLite file only.<p>With this approach you get a URL you can query directly from your FE if you want, e.g. fetch() can send SELECT * ... queries straight from your users' browser. You could plot a graph from a static React frontend, or observablehq.com editor, with no persistent backend needed. So at times when nobody's using your app, 100% of your stack can scale to zero with obvious cloud spend advantages. And even if you exceed free tier limits, being PAYG offers a good chance you'll come out ahead on hosting costs anyway.<p>NB: Seafowl is an early stage project, so it's not really suitable if you need transactions or fast single-row writes. Otherwise, this could be a nice way to get free database hosting at a big 3 cloud provider, especially for e.g. read-only analytical reporting queries.<p>Feedback and suggestions are appreciated. Hope it helps you! More available if you want [3].<p>[0] <a href="https://seafowl.io/docs/getting-started/introduction" rel="nofollow">https://seafowl.io/docs/getting-started/introduction</a><p>[1] <a href="https://cloud.google.com/run/pricing#cpu-requests" rel="nofollow">https://cloud.google.com/run/pricing#cpu-requests</a><p>[2] Neon is another interesting project that separates compute and storage. <a href="https://neon.tech/blog/architecture-decisions-in-neon" rel="nofollow">https://neon.tech/blog/architecture-decisions-in-neon</a><p>One issue I observed was a noticeably longer startup time vs this FUSE approach, which I believe may be related to Postgres connection setup time/roundtrips. Looking forward to trying Neon again in future.<p>[3] <a href="https://www.splitgraph.com/blog/deploying-serverless-seafowl" rel="nofollow">https://www.splitgraph.com/blog/deploying-serverless-seafowl</a>
Show HN: Codespelunker – A command line search tool with TUI and HTTP modes
Show HN: Codespelunker – A command line search tool with TUI and HTTP modes
Show HN: FemtoGPT – Pure Rust implementation of a GPT language model
Show HN: FemtoGPT – Pure Rust implementation of a GPT language model
Show HN: Tiny Code Improver
Hey, fellow hackers! I'm excited to share my latest project, TinyCodeImprover, which has become an indispensable tool in my coding workflow.<p>What is TinyCodeImprover?<p>TinyCodeImprover leverages the power of GPT-4 to analyze and enhance your project files. By simply loading your code into the GPT-4 context, you can ask questions about your code, identify bugs, and even request GPT-4 to write code snippets across multiple files simultaneously.<p>The Story Behind its Creation<p>As a programmer, I frequently turn to GPT-4 for assistance with topics outside my expertise. However, I found the process of copying and pasting code snippets into the chat cumbersome and time-consuming. That's when I had an idea: a tool that seamlessly integrates GPT-4 into my coding environment.<p>A month ago, during a flight from Bangkok to Dubai, I developed the first prototype of TinyCodeImprover. It allowed me to feed project files directly to GPT-4 and request code improvements based on my specifications! It even wrote a Readme for itself – quite mind-blowing!<p>Refining the Process<p>To maximize the effectiveness of TinyCodeImprover, I discovered the importance of employing a critical approach. I created special commands, ".critic" and ".resolver," to initiate self-reflection, enabling GPT-4 to identify its own mistakes in approximately 30% of cases.<p>Since its inception, I've integrated TinyCodeImprover into four different projects, transforming error-fixing into an enjoyable experience, even when dealing with CSS challenges. It has proven useful not only for code but also for any type of text.
Show HN: Tiny Code Improver
Hey, fellow hackers! I'm excited to share my latest project, TinyCodeImprover, which has become an indispensable tool in my coding workflow.<p>What is TinyCodeImprover?<p>TinyCodeImprover leverages the power of GPT-4 to analyze and enhance your project files. By simply loading your code into the GPT-4 context, you can ask questions about your code, identify bugs, and even request GPT-4 to write code snippets across multiple files simultaneously.<p>The Story Behind its Creation<p>As a programmer, I frequently turn to GPT-4 for assistance with topics outside my expertise. However, I found the process of copying and pasting code snippets into the chat cumbersome and time-consuming. That's when I had an idea: a tool that seamlessly integrates GPT-4 into my coding environment.<p>A month ago, during a flight from Bangkok to Dubai, I developed the first prototype of TinyCodeImprover. It allowed me to feed project files directly to GPT-4 and request code improvements based on my specifications! It even wrote a Readme for itself – quite mind-blowing!<p>Refining the Process<p>To maximize the effectiveness of TinyCodeImprover, I discovered the importance of employing a critical approach. I created special commands, ".critic" and ".resolver," to initiate self-reflection, enabling GPT-4 to identify its own mistakes in approximately 30% of cases.<p>Since its inception, I've integrated TinyCodeImprover into four different projects, transforming error-fixing into an enjoyable experience, even when dealing with CSS challenges. It has proven useful not only for code but also for any type of text.
Show HN: SQLPage – Build Dynamic Websites with Just SQL Queries
Hey Hacker News!<p>I wanted to share the open source project I have been working on during the last year: SQLPage, a tool to build small web applications entirely in SQL.<p>Building web applications with just SQL isn't as crazy as it seems. Most simple applications can be expressed declaratively as just data queries that fill pre-defined web components.<p>I'd love to hear your feedback and thoughts on it. Would you potentially use it? How can it be improved?<p>Website: <a href="https://sql.ophir.dev/" rel="nofollow">https://sql.ophir.dev/</a>
Github: <a href="https://github.com/lovasoa/SQLpage">https://github.com/lovasoa/SQLpage</a>
Example app: <a href="https://conundrum.ophir.dev/" rel="nofollow">https://conundrum.ophir.dev/</a>
Show HN: SQLPage – Build Dynamic Websites with Just SQL Queries
Hey Hacker News!<p>I wanted to share the open source project I have been working on during the last year: SQLPage, a tool to build small web applications entirely in SQL.<p>Building web applications with just SQL isn't as crazy as it seems. Most simple applications can be expressed declaratively as just data queries that fill pre-defined web components.<p>I'd love to hear your feedback and thoughts on it. Would you potentially use it? How can it be improved?<p>Website: <a href="https://sql.ophir.dev/" rel="nofollow">https://sql.ophir.dev/</a>
Github: <a href="https://github.com/lovasoa/SQLpage">https://github.com/lovasoa/SQLpage</a>
Example app: <a href="https://conundrum.ophir.dev/" rel="nofollow">https://conundrum.ophir.dev/</a>
Show HN: SQLPage – Build Dynamic Websites with Just SQL Queries
Hey Hacker News!<p>I wanted to share the open source project I have been working on during the last year: SQLPage, a tool to build small web applications entirely in SQL.<p>Building web applications with just SQL isn't as crazy as it seems. Most simple applications can be expressed declaratively as just data queries that fill pre-defined web components.<p>I'd love to hear your feedback and thoughts on it. Would you potentially use it? How can it be improved?<p>Website: <a href="https://sql.ophir.dev/" rel="nofollow">https://sql.ophir.dev/</a>
Github: <a href="https://github.com/lovasoa/SQLpage">https://github.com/lovasoa/SQLpage</a>
Example app: <a href="https://conundrum.ophir.dev/" rel="nofollow">https://conundrum.ophir.dev/</a>
Show HN: CloneDub – Convert audio into any language using the same voices
Hey everyone! Excited to share CloneDub - a tool that allows you to convert audio into any language while keeping the same voices.<p>We currently translate to: English, Spanish, French, Hindi, Italian, German, Polish, and Portuguese.<p>The voices are cloned so that the podcasters sound the same! For example, if you were to upload a Lex Fridman podcast interviewing Sam Altman and requested that it was translated into Hindi, it would sound like Lex Fridman and Sam Altman, but just in a different language/accent!<p>How does CloneDub work?<p>Audio Upload: Upload your audio file, paste a YouTube Link, or the link to your mp3/wav file<p>Output Language Selection: Choose the language you’d wish to convert the audio to - we support English, Spanish, French, Hindi, Italian, German, Polish, and Portuguese.<p>Generate, Download & Share: Wait for the output to generate, download, and share
* Note we only allow you to use CloneDub for one episode at a time and only allow for up to 10 min of audio for now as it is still in beta<p>You can view a demo and try it out here:clonedub.com<p>We decided to make CloneDub for 2 main reasons:
We love building for creators and have seen the impact that multilingual support for subtitles and dubbing has had for other industries (eg. on Netflix) / growing up watching Bollywood movies that we could only understand because of subtitles !
We have family members who are not great at understanding
English and thus have had limited access to information, educational content, and entertainment that we had the luxury of having just based off the language we speak<p>Let us know what you think
Show HN: CloneDub – Convert audio into any language using the same voices
Hey everyone! Excited to share CloneDub - a tool that allows you to convert audio into any language while keeping the same voices.<p>We currently translate to: English, Spanish, French, Hindi, Italian, German, Polish, and Portuguese.<p>The voices are cloned so that the podcasters sound the same! For example, if you were to upload a Lex Fridman podcast interviewing Sam Altman and requested that it was translated into Hindi, it would sound like Lex Fridman and Sam Altman, but just in a different language/accent!<p>How does CloneDub work?<p>Audio Upload: Upload your audio file, paste a YouTube Link, or the link to your mp3/wav file<p>Output Language Selection: Choose the language you’d wish to convert the audio to - we support English, Spanish, French, Hindi, Italian, German, Polish, and Portuguese.<p>Generate, Download & Share: Wait for the output to generate, download, and share
* Note we only allow you to use CloneDub for one episode at a time and only allow for up to 10 min of audio for now as it is still in beta<p>You can view a demo and try it out here:clonedub.com<p>We decided to make CloneDub for 2 main reasons:
We love building for creators and have seen the impact that multilingual support for subtitles and dubbing has had for other industries (eg. on Netflix) / growing up watching Bollywood movies that we could only understand because of subtitles !
We have family members who are not great at understanding
English and thus have had limited access to information, educational content, and entertainment that we had the luxury of having just based off the language we speak<p>Let us know what you think
Show HN: CloneDub – Convert audio into any language using the same voices
Hey everyone! Excited to share CloneDub - a tool that allows you to convert audio into any language while keeping the same voices.<p>We currently translate to: English, Spanish, French, Hindi, Italian, German, Polish, and Portuguese.<p>The voices are cloned so that the podcasters sound the same! For example, if you were to upload a Lex Fridman podcast interviewing Sam Altman and requested that it was translated into Hindi, it would sound like Lex Fridman and Sam Altman, but just in a different language/accent!<p>How does CloneDub work?<p>Audio Upload: Upload your audio file, paste a YouTube Link, or the link to your mp3/wav file<p>Output Language Selection: Choose the language you’d wish to convert the audio to - we support English, Spanish, French, Hindi, Italian, German, Polish, and Portuguese.<p>Generate, Download & Share: Wait for the output to generate, download, and share
* Note we only allow you to use CloneDub for one episode at a time and only allow for up to 10 min of audio for now as it is still in beta<p>You can view a demo and try it out here:clonedub.com<p>We decided to make CloneDub for 2 main reasons:
We love building for creators and have seen the impact that multilingual support for subtitles and dubbing has had for other industries (eg. on Netflix) / growing up watching Bollywood movies that we could only understand because of subtitles !
We have family members who are not great at understanding
English and thus have had limited access to information, educational content, and entertainment that we had the luxury of having just based off the language we speak<p>Let us know what you think
Show HN: SQL Dry Runs with SQL Simulator
My name is Weston Goodwin. I created a tool called SQL Simulator which allows you to do Dry Runs with your SQL Scripts. The reason I created the tool was because I wanted to verify that my SQL scripts did what I thought they would do without executing them against the database.<p>It is similar in concept to Redgate SQL Clone or Windocs. If you are not familiar with these tools they make clones of your database. The key difference with SQL Simulator is, it only makes a clone of the database objects affected by your sql script, not the entire database. Nor does it copy the entire table (if your sql has where clauses). Once those database objects have been cloned, SQL Simulator then executes your script against the cloned database it created.<p>This software is only compatible with Oracle and SQL Server at the present time. My plan is to make it compatible with more databases in the future.<p>For a more in depth technical overview click here:
<a href="https://docs.tribalknowledge.tech/ratifier-tutorials/sql-simulator/technical-overview" rel="nofollow">https://docs.tribalknowledge.tech/ratifier-tutorials/sql-sim...</a><p>You can download the software here:
<a href="https://www.tribalknowledge.tech/download.html" rel="nofollow">https://www.tribalknowledge.tech/download.html</a><p>You can read the documentation here:
<a href="https://docs.tribalknowledge.tech/ratifier-tutorials/sql-simulator" rel="nofollow">https://docs.tribalknowledge.tech/ratifier-tutorials/sql-sim...</a>
Show HN: SQL Dry Runs with SQL Simulator
My name is Weston Goodwin. I created a tool called SQL Simulator which allows you to do Dry Runs with your SQL Scripts. The reason I created the tool was because I wanted to verify that my SQL scripts did what I thought they would do without executing them against the database.<p>It is similar in concept to Redgate SQL Clone or Windocs. If you are not familiar with these tools they make clones of your database. The key difference with SQL Simulator is, it only makes a clone of the database objects affected by your sql script, not the entire database. Nor does it copy the entire table (if your sql has where clauses). Once those database objects have been cloned, SQL Simulator then executes your script against the cloned database it created.<p>This software is only compatible with Oracle and SQL Server at the present time. My plan is to make it compatible with more databases in the future.<p>For a more in depth technical overview click here:
<a href="https://docs.tribalknowledge.tech/ratifier-tutorials/sql-simulator/technical-overview" rel="nofollow">https://docs.tribalknowledge.tech/ratifier-tutorials/sql-sim...</a><p>You can download the software here:
<a href="https://www.tribalknowledge.tech/download.html" rel="nofollow">https://www.tribalknowledge.tech/download.html</a><p>You can read the documentation here:
<a href="https://docs.tribalknowledge.tech/ratifier-tutorials/sql-simulator" rel="nofollow">https://docs.tribalknowledge.tech/ratifier-tutorials/sql-sim...</a>
Show HN: Google Code Jam Archive
Hi HN,<p>As many of you already know, Google has discontinued their coding competitions and is shutting down the competitions website.
Before it's gone forever, I've scraped everything I could from their website and set up my own archive.<p>(Disclaimer: I'm not affiliated with Google besides participating in these contests years ago)<p>While the initial version was ready back in March, today I'm rolling out big and hopefully the final update, so this might be a good time to share it with the HN community.<p>Everything is static HTML and SQLite archives (with a very minimal backend to serve files directly from SQLite), so you can easily grab your own copy.
May these 3.5 million source files be a nice training dataset for some fancy future AI!<p>Some useless stats:<p>Tabs or spaces? 28% tabs vs 72% spaces for the whole dataset, but quite unexpectedly, 66% tabs vs 34% spaces if we consider only the final rounds.<p>Most used languages: 63% C/C++, 20% Python, 12% Java, 2% C#, with others less than 1% each. For the final rounds it's 83% C/C++, 13% Java, 2% Python.
Show HN: Google Code Jam Archive
Hi HN,<p>As many of you already know, Google has discontinued their coding competitions and is shutting down the competitions website.
Before it's gone forever, I've scraped everything I could from their website and set up my own archive.<p>(Disclaimer: I'm not affiliated with Google besides participating in these contests years ago)<p>While the initial version was ready back in March, today I'm rolling out big and hopefully the final update, so this might be a good time to share it with the HN community.<p>Everything is static HTML and SQLite archives (with a very minimal backend to serve files directly from SQLite), so you can easily grab your own copy.
May these 3.5 million source files be a nice training dataset for some fancy future AI!<p>Some useless stats:<p>Tabs or spaces? 28% tabs vs 72% spaces for the whole dataset, but quite unexpectedly, 66% tabs vs 34% spaces if we consider only the final rounds.<p>Most used languages: 63% C/C++, 20% Python, 12% Java, 2% C#, with others less than 1% each. For the final rounds it's 83% C/C++, 13% Java, 2% Python.
Show HN: Rarbg on IPFS
Show HN: Rarbg on IPFS
Show HN: Rarbg on IPFS