The best Hacker News stories from Show from the past day
Latest posts:
Show HN: Qdorks.com – Advanced Google search query composer
Hi HN,<p>qdorks.com is an advanced Google search query composer I have been working on lately. It makes it super easy to write complex Google search queries and save them for later usage.<p>Main features:<p>* Query composer with complex grouping, logical and exclusion operators per clause.<p>* Share your queries with others so they can easily copy and modify the query.<p>* No need to register; only when you want to save the queries.<p>* AI support for PRO users.<p>* More to come...<p>I am pretty happy with how it works and would love your feedback! Happy to answer any questions. Thank you!
Show HN: Qdorks.com – Advanced Google search query composer
Hi HN,<p>qdorks.com is an advanced Google search query composer I have been working on lately. It makes it super easy to write complex Google search queries and save them for later usage.<p>Main features:<p>* Query composer with complex grouping, logical and exclusion operators per clause.<p>* Share your queries with others so they can easily copy and modify the query.<p>* No need to register; only when you want to save the queries.<p>* AI support for PRO users.<p>* More to come...<p>I am pretty happy with how it works and would love your feedback! Happy to answer any questions. Thank you!
Show HN: Taipy – Turns Data and AI algorithms into full web applications
Show HN: Play a pen-and-paper game that is almost unknown in the US and Europe
Show HN: Play a pen-and-paper game that is almost unknown in the US and Europe
Show HN: Play a pen-and-paper game that is almost unknown in the US and Europe
Show HN: Play a pen-and-paper game that is almost unknown in the US and Europe
Show HN: Bi-directional sync between Postgres and SQLite
Hi HN,<p>Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way.<p>Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is designed to be stack-agnostic.<p>If you’d like to see a simple demo, check out the pebbles widget on the landing page here: <a href="https://www.powersync.com/" rel="nofollow noreferrer">https://www.powersync.com/</a><p>We wrote about our architecture and design philosophy here: <a href="https://www.powersync.com/blog/introducing-powersync-v1-0-postgres-sqlite-sync-layer" rel="nofollow noreferrer">https://www.powersync.com/blog/introducing-powersync-v1-0-po...</a><p>This covers amongst other things how we designed the system for scalable dynamic partial replication, why we use a server authority architecture based on an event log instead of CRDTs for merging changes, and the approach to consistency.<p>Our docs can be found here: <a href="https://docs.powersync.com/" rel="nofollow noreferrer">https://docs.powersync.com/</a><p>We would love to hear your feedback!
- Ralf, Conrad, Kobie, Phillip and team
Show HN: Bi-directional sync between Postgres and SQLite
Hi HN,<p>Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way.<p>Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is designed to be stack-agnostic.<p>If you’d like to see a simple demo, check out the pebbles widget on the landing page here: <a href="https://www.powersync.com/" rel="nofollow noreferrer">https://www.powersync.com/</a><p>We wrote about our architecture and design philosophy here: <a href="https://www.powersync.com/blog/introducing-powersync-v1-0-postgres-sqlite-sync-layer" rel="nofollow noreferrer">https://www.powersync.com/blog/introducing-powersync-v1-0-po...</a><p>This covers amongst other things how we designed the system for scalable dynamic partial replication, why we use a server authority architecture based on an event log instead of CRDTs for merging changes, and the approach to consistency.<p>Our docs can be found here: <a href="https://docs.powersync.com/" rel="nofollow noreferrer">https://docs.powersync.com/</a><p>We would love to hear your feedback!
- Ralf, Conrad, Kobie, Phillip and team
Show HN: Bi-directional sync between Postgres and SQLite
Hi HN,<p>Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way.<p>Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is designed to be stack-agnostic.<p>If you’d like to see a simple demo, check out the pebbles widget on the landing page here: <a href="https://www.powersync.com/" rel="nofollow noreferrer">https://www.powersync.com/</a><p>We wrote about our architecture and design philosophy here: <a href="https://www.powersync.com/blog/introducing-powersync-v1-0-postgres-sqlite-sync-layer" rel="nofollow noreferrer">https://www.powersync.com/blog/introducing-powersync-v1-0-po...</a><p>This covers amongst other things how we designed the system for scalable dynamic partial replication, why we use a server authority architecture based on an event log instead of CRDTs for merging changes, and the approach to consistency.<p>Our docs can be found here: <a href="https://docs.powersync.com/" rel="nofollow noreferrer">https://docs.powersync.com/</a><p>We would love to hear your feedback!
- Ralf, Conrad, Kobie, Phillip and team
Show HN: Bi-directional sync between Postgres and SQLite
Hi HN,<p>Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way.<p>Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is designed to be stack-agnostic.<p>If you’d like to see a simple demo, check out the pebbles widget on the landing page here: <a href="https://www.powersync.com/" rel="nofollow noreferrer">https://www.powersync.com/</a><p>We wrote about our architecture and design philosophy here: <a href="https://www.powersync.com/blog/introducing-powersync-v1-0-postgres-sqlite-sync-layer" rel="nofollow noreferrer">https://www.powersync.com/blog/introducing-powersync-v1-0-po...</a><p>This covers amongst other things how we designed the system for scalable dynamic partial replication, why we use a server authority architecture based on an event log instead of CRDTs for merging changes, and the approach to consistency.<p>Our docs can be found here: <a href="https://docs.powersync.com/" rel="nofollow noreferrer">https://docs.powersync.com/</a><p>We would love to hear your feedback!
- Ralf, Conrad, Kobie, Phillip and team
Show HN: Docu – Never sign a sketchy contract again. GPT-4 contract review
A simple tool for people like me whose brain hurts when they read any legal document full of bloated jargon.<p>It's called Docu and it's makes contract review super simple. It gives you a very readable summary, highlights beneficial clauses, flags potential risks, and gives you actions you can take to make the contract work for you.<p>Build on OpenAI assistant API using a combination of prompts.<p><a href="https://docu.review" rel="nofollow noreferrer">https://docu.review</a>
Show HN: pgxman – npm for Postgres extensions
pgxman is npm for Postgres extensions, simplifying the discovery and use of extensions so you can easily enhance your applications.<p>Installing and updating Postgres extensions is an uphill battle. You're left searching for the right build tools and grappling with often unclear and incomplete compiling instructions to even try one out. But with pgxman, we've streamlined the process to one simple step: pgxman install [extension name].<p>For example, to build parquet_s3_fdw manually, you'd need to:<p>1. Download the parquet_s3_fdw source code;<p>2. Figure out how to build it by looking at README. When unclear, look at the source code how to build it. The README of parquet_s3_fdw says it needs libarrow, libparquet & aws_sdk. Readme doesn’t say where to get them.<p>3. Make sure all dependencies are available to build the project. Either install them from apt, if available, or build them manually if not. For parquet_s3_fdw aws_sdk has to be built manually — it’s not available in any apt repos<p>4. Build the extension targeting the correct OS, CPU architecture and Postgres version.<p>5. Determine and build to the right path /usr/lib/postgresql/15/lib - otherwise, Postgres wouldn’t be able to find them.<p>6. Repeat across all relevant Postgres instances. Hopefully, these Postgres versions are recent or else you’ll have to update postgres, set maintenance window, etc.<p>* Added friction: Since parquet_s3_fdw is not designed to use in a cloud environment, and we forked it to make changes to make it possible to use.<p>Using pgxman, you can just do:<p><pre><code> pgxman install s3_parquet_fdw
</code></pre>
pgxman integrates with your system package manager, ensuring the correct versions are installed without extra packages from any shared dependencies between extensions. pgxman’s automated build system creates [APT] packages for each Postgres version, platform, and OS supported by the extension. Extensions are built from a “buildkit” formula, written in YAML, and are contributed through GitHub.<p>To install pgxman, you can do<p><pre><code> brew install pgxman/tap/pgxman
</code></pre>
or, if you don't mind pipe-to-shell,<p><pre><code> curl -sfl https://install.pgx.sh | sh -
</code></pre>
If you'd like to learn more, we have an extensive blog post here: <a href="https://www.hydra.so/blog-posts/the-design-of-postgres-extension-manager-pgxman">https://www.hydra.so/blog-posts/the-design-of-postgres-exten...</a>.
Show HN: pgxman – npm for Postgres extensions
pgxman is npm for Postgres extensions, simplifying the discovery and use of extensions so you can easily enhance your applications.<p>Installing and updating Postgres extensions is an uphill battle. You're left searching for the right build tools and grappling with often unclear and incomplete compiling instructions to even try one out. But with pgxman, we've streamlined the process to one simple step: pgxman install [extension name].<p>For example, to build parquet_s3_fdw manually, you'd need to:<p>1. Download the parquet_s3_fdw source code;<p>2. Figure out how to build it by looking at README. When unclear, look at the source code how to build it. The README of parquet_s3_fdw says it needs libarrow, libparquet & aws_sdk. Readme doesn’t say where to get them.<p>3. Make sure all dependencies are available to build the project. Either install them from apt, if available, or build them manually if not. For parquet_s3_fdw aws_sdk has to be built manually — it’s not available in any apt repos<p>4. Build the extension targeting the correct OS, CPU architecture and Postgres version.<p>5. Determine and build to the right path /usr/lib/postgresql/15/lib - otherwise, Postgres wouldn’t be able to find them.<p>6. Repeat across all relevant Postgres instances. Hopefully, these Postgres versions are recent or else you’ll have to update postgres, set maintenance window, etc.<p>* Added friction: Since parquet_s3_fdw is not designed to use in a cloud environment, and we forked it to make changes to make it possible to use.<p>Using pgxman, you can just do:<p><pre><code> pgxman install s3_parquet_fdw
</code></pre>
pgxman integrates with your system package manager, ensuring the correct versions are installed without extra packages from any shared dependencies between extensions. pgxman’s automated build system creates [APT] packages for each Postgres version, platform, and OS supported by the extension. Extensions are built from a “buildkit” formula, written in YAML, and are contributed through GitHub.<p>To install pgxman, you can do<p><pre><code> brew install pgxman/tap/pgxman
</code></pre>
or, if you don't mind pipe-to-shell,<p><pre><code> curl -sfl https://install.pgx.sh | sh -
</code></pre>
If you'd like to learn more, we have an extensive blog post here: <a href="https://www.hydra.so/blog-posts/the-design-of-postgres-extension-manager-pgxman">https://www.hydra.so/blog-posts/the-design-of-postgres-exten...</a>.
Show HN: Python-Type-Challenges, master Python typing with online exercises
Hi HN, I'm excited to share Python-Type-Challenges, a collection of hands-on, interactive challenges designed to help Python developers master type annotations. Whether you're new to type hints or looking to deepen your understanding, these exercises provide a fun and educational way to explore Python's type system. I'd love to get your feedback and contributions!<p><a href="https://github.com/laike9m/Python-Type-Challenges">https://github.com/laike9m/Python-Type-Challenges</a>
Show HN: Python-Type-Challenges, master Python typing with online exercises
Hi HN, I'm excited to share Python-Type-Challenges, a collection of hands-on, interactive challenges designed to help Python developers master type annotations. Whether you're new to type hints or looking to deepen your understanding, these exercises provide a fun and educational way to explore Python's type system. I'd love to get your feedback and contributions!<p><a href="https://github.com/laike9m/Python-Type-Challenges">https://github.com/laike9m/Python-Type-Challenges</a>
Resume Matcher – An open source, free tool to improve your resume
Show HN: Error return traces for Go, inspired by Zig
Show HN: Error return traces for Go, inspired by Zig
Show HN: Error return traces for Go, inspired by Zig