Presto
pirsch
Our great sponsors
Presto | pirsch | |
---|---|---|
14 | 41 | |
15,522 | 821 | |
0.9% | 3.7% | |
9.9 | 9.0 | |
about 18 hours ago | 9 days ago | |
Java | Go | |
Apache License 2.0 | GNU Affero General Public License v3.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Presto
-
Multi-Database Support in DuckDB
We have some of this functionality in Presto (https://github.com/prestodb/presto), but it takes fair bit of work to implement it for all the different backends.
-
Rust std:fs slower than Python
Note that glibc has a similar problem in multithreaded contexts. It strands unused memory in thread-local pools, which grows your memory usage over time like a memory leak. We got lower memory usage that didn't grow over time by switching to jemalloc.
Example of this: https://github.com/prestodb/presto/issues/8993
-
Ask HN: What are some SQL transpilers?
SQLGlot is a really awesome tool that can. transpile SQL to various dialects -- https://news.ycombinator.com/item?id=31981568. What are some other SQL transpilers? I believe Presto (https://github.com/prestodb/presto) includes one, but what are others?
-
After a few recent events, opening a Linux terminal in public places is a big no-no
export MVNW_VERBOSE=true git clone https://github.com/prestodb/presto.git cd presto bash ./mvnw clean install
- Compile the Minecraft Server (Java Edition) to Native with GraalVM Native Image
-
What are y'all learning right now?
more specifically, recently started learning about Presto [paper], and have been diving deeper into [source] code.
-
DeWitt Clause, or Can You Benchmark %DATABASE% and Get Away With It
Presto
- Let's write a compiler, part 5: A code generator
-
Memoization in Cost-based Optimizers
You may find a similar design in many production-grade heuristic optimizers. In our previous blog post about Presto, we discussed the Memo class that manages such references. In Apache Calcite, the heuristic optimizer HepPlanner models node references through the class HepRelVertex.
pirsch
-
Must-Have Features to Look for in a Blogging Platform
Pirsch Analytics (paid)
-
Using Analytics on My Website
I was also looking for server-side analytics, created my own, and now it's a product! The idea is that tracking can be done from both, a JS snippet (for easy integration) and an API. Both rely on fingerprinting and almost provide the same set of features. The API just lacks screen resolution. The method is GDPR (and CCPA and whatnot) compliant.
Original article: https://marvinblum.de/blog/server-side-tracking-without-cook...
Product: https://pirsch.io
before this comes up again: Yes, we checked professionally with an external DPO and it was checked by some companies you've probably heard of externally.
-
Site analytics for open source project?
Take a look at Pirsch. You can find a demo with real data here.
-
Ask HN: Side project of more that $2k monthly revenue what's your project?
I'm building Pirsch Analytics [0], a privacy-friendly web analytics tool. I think it took the two of us ~1.5 years to get to $2000 MRR. Currently we're setting just above $4000 MRR.
It started as an experiment for my personal website and I was in the same position as you're right now. We were already working on a Notion like app to take notes, but didn't make any money and probably went into the wrong direction. As my prototype seemed to work quite well, we decided to turn it into a product.
My initial goal was to do server-side analytics without the downsides of parsing access logs, but of course we now also have a "regular" JS snippet integration.
You can learn more about our journey here [1] and on our blog [2]. Let me know if you have any questions!
-
I'm building a new SaaS tool: open source analytics for the web
Not saying you shouldn’t or anything, but Plausible, Pirsch, and Umami are already privacy friendly open-source analytics.
-
Ask HN: Any alternatives to Google Analytics that don't require cookies?
Pirsch has been easy and great IME.
-
Ask HN: What’s your startup’s analytics setup? (2023)
If you use Google Analytics, you can get in a lot of trouble if you don't prompt the user with the cookie policy pop up. GDPR is a MF. I feel like it's bad UX to have that pop up, and I don't want to get in trouble, so I opt to use more bare-bones analytics and do a lot of custom logging myself.
The tool I use specifically is https://pirsch.io/, which is very privacy friendly and doesn't have any of the stalky type stuff that Google Analytics has as default. Using this, you don't need to have the GDPR compliance pop-up.
-
Recommendations for GDPR/CCPA compliant privacy policy (or just ditching Google Analytics)?
Pirsch
-
We built a $1M ARR open source SaaS
I also started a privacy-friendly analytics SaaS without looking at the market. Sometimes it's better to just get started. Otherwise you probably won't start doing anything, as there are existing products most of the time. In my case, I was looking for a Go (golang) solution that I could embed in my website, as a library so to speak, and just turned it into a product later as I was looking for a new project to work on.
We're now at $1500 MRR and growing. I'm also opposing the position of "just being against GA" now and we try to differentiate more. It's almost impossible to get anyone away from GA who does do performance marketing. So I don't quite see how Plausible or other privacy-friendly products are a replacement. But most websites that use GA just don't have to, because they don't rely so much on ads or personal data to get value.
Our product: https://pirsch.io
-
We don’t use a staging environment
I use a somewhat similar approach for Pirsch [0]. It's build so that I can run it locally, basically as a fully fledged staging environment. Databases run in Docker, everything else is started using modd [1]. This has proven to be a good setup for quick iterations and testing. I can quickly run all tests on my laptop (Go and TypeScript) and even import data from production to see if the statistics are correct for real data. Of course, there are some things that need to be mocked, like automated backups, but so fare it turns out to work really well.
You can find more on our blog [2] if you would like to know more.
What are some alternatives?
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
Apache Phoenix - Apache Phoenix
Apache Calcite - Apache Calcite
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
jOOQ - jOOQ is the best way to write SQL in Java
Plausible Analytics - Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.
Spring Data JPA - Simplifies the development of creating a JPA-based data access layer.
Apache Drill - Apache Drill is a distributed MPP query layer for self describing data
Apache Hive - Apache Hive
Querydsl - Unified Queries for Java
Crate - CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
JSqlParser - JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern