pg_partman
Milvus
pg_partman | Milvus | |
---|---|---|
7 | 105 | |
1,879 | 26,979 | |
2.4% | 2.5% | |
7.0 | 10.0 | |
23 days ago | 4 days ago | |
PLpgSQL | Go | |
GNU General Public License v3.0 or later | Apache License 2.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.
pg_partman
-
Dear data engineers
Assuming these are the types of insights you're looking for, you'll probably look for a way to aggregate data points across/within geographies. postgis is an open source extension for postgres that can help you with this, but there's also quite a few python tools that can help you explore the data, such as geopandas, folium, geoplot. Depending on volume, you might want to partition the data for query performance, and there's another extension pg_partman that can help with that. Just noticed some other posts have recommended something similar.
- Pgpartman: Partition Management Extension for Postgres
-
Which is the best way to automate backing up data monthly of tables in a schema and then deleting them?
pg_partman is in RDS >12.5 (here). Pg_partman makes managing data retention relatively easy.
- Partitioning in Postgres, 2022 Edition
-
TimescaleDB 2.7 vs. PostgreSQL 14
Whenever I see these posts from TimescaleDB, I always want to ask them how it compares in performance to alternative extensions that implement the same features, rather than just comparing TimescaleDB to vanilla PostgreSQL.
For example, they mention their automated data retention and how it's achieved with one SQL command, and how DELETEing records is a very costly operation, and how "even if you were using Postgres declarative partitioning you’d still need to automate the process yourself, wasting precious developer time, adding additional requirements, and implementing bespoke code that needs to be supported moving forward".
There's zero mention anywhere of pg_partman, which does all of these things for you equally as simply, and is a fully OSS free alternative [0].
I get that it's a PG extension that competes with their product. I know that TimescaleDB does a few other things that pg_partman does not. But I can't help but find its (seemingly) purposeful omission in these, otherwise very thorough blog posts, misleading.
[0] https://github.com/pgpartman/pg_partman/blob/master/doc/pg_p...
-
Table partitioning by months of the year?
Take a look into this extension which would take care of a good amount of automation for you.
-
Replicating a dynamically partitioned table possible in Postgres 13
You might want to look into pg_partman which has many useful tools around semi-automatic partitioning. According to their documentation they already have a procedure that will do exactly that: create new partitions based on the rows in the default partition.
Milvus
-
Computer Vision Meetup: Develop a Legal Search Application from Scratch using Milvus and DSPy!
Legal practitioners often need to find specific cases and clauses across thousands of dense documents. While traditional keyword-based search techniques are useful, they fail to fully capture semantic content of queries and case files. Vector search engines and large language models provide an intriguing alternative. In this talk, I will show you how to build a legal search application using the DSPy framework and the Milvus vector search engine.
-
Ask HN: Who is hiring? (April 2024)
Zilliz (zilliz.com) | Hybrid/ONSITE (SF, NYC) | Full-time
I am part of the hiring team for DevRel
NYC - https://boards.greenhouse.io/zilliz/jobs/4307910005
SF - https://boards.greenhouse.io/zilliz/jobs/4317590005
Zilliz is the company behind Milvus (https://github.com/milvus-io/milvus), the most starred vector database on GitHub. Milvus is a distributed vector database that shines in 1B+ vector use cases. Examples include autonomous driving, e-commerce, and drug discovery. (and, of course, RAG)
We are also hiring for other roles that I am not personally involved in the hiring process for such as product managers, software engineers, and recruiters.
-
Unlock Advanced Search Capabilities with Milvus and Read about RAG
Get started with Milvus on GitHub.
-
Milvus VS pgvecto.rs - a user suggested alternative
2 projects | 13 Mar 2024
-
How to choose the right type of database
Milvus: An open-source vector database designed for AI and ML applications. It excels in handling large-scale vector similarity searches, making it suitable for recommendation systems, image and video retrieval, and natural language processing tasks.
-
Simplifying the Milvus Selection Process
Selecting the right version of open-source Milvus is important to the success of any project leveraging vector search technology. With Milvus offering different versions of its vector database tailored to varying requirements, understanding the significance of selecting the correct version is key for achieving desired outcomes.
-
7 Vector Databases Every Developer Should Know!
Milvus is an open-source vector database designed to handle large-scale similarity search and vector indexing. It supports multiple index types and offers highly efficient search capabilities, making it suitable for a wide range of AI and ML applications, including image and video recognition, natural language processing, and recommendation systems.
-
Ask HN: Who is hiring? (February 2024)
Zilliz is hiring! We're looking for REMOTE and/or HYBRID roles in SF
Zilliz is the company behind Milvus (https://github.com/milvus-io/milvus), the most widely adopted vector database. Vector databases are a crucial piece of any technology stack looking to take advantage of unstructured data. Most recently and notably, Retrieval Augmented Generation (RAG). For RAG, vector databases like Milvus are used as the tool to inject customized data. In other words, vector databases make things like customized chat bots, personalized product recommendations, and more possible.
We are hiring for Developer Advocates, Senior+ Level Engineers and Product people, and Talent Acquisition. Check out all the roles here: https://zilliz.com/careers
-
Qdrant, the Vector Search Database, raised $28M in a Series A round
Good on them, I know the crustaceans are out here happy about this raise for a Rust based Vector DB!
(now I'm gonna plug what I work on)
If you're interested in a more scalable vector database written in Go, check out Milvus (https://github.com/milvus-io/milvus)
-
Open Source Advent Fun Wraps Up!
But before we do, I do want to say that 🤩 all these lovely Open-Source projects would love a little 🎉💕 love by getting a GitHub star ⭐ for their efforts. Including Open Source Milvus 🥰
What are some alternatives?
periods - PERIODs and SYSTEM VERSIONING for PostgreSQL
pgvector - Open-source vector similarity search for Postgres
pgddl - DDL eXtractor functions for PostgreSQL (ddlx)
faiss - A library for efficient similarity search and clustering of dense vectors.
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
qdrant - Qdrant - High-performance, massive-scale Vector Database for the next generation of AI. Also available in the cloud https://cloud.qdrant.io/
postgres-aws-s3 - aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
Weaviate - Weaviate is an open-source vector database that stores both objects and vectors, allowing for the combination of vector search with structured filtering with the fault tolerance and scalability of a cloud-native database.
practical-sql - Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).
Elasticsearch - Free and Open, Distributed, RESTful Search Engine
metagration - Metagration: PostgreSQL Migrator in PostgreSQL
Face Recognition - The world's simplest facial recognition api for Python and the command line