semvec/pypi-packages huggingface dataset:
query-farm-flight-server 0.1.17
A framework for building Arrow Flight servers for the DuckDB Airport extension with robust authentication, schema management, and data handling capabilities.
Requires Python: >=3.12
Keywords: airport, arrow, arrow flight, duckdb, duckdb airport, flight, predicate pushdown, predicates, sql, sql parsing

# `query-farm-flight-server`

A robust Python framework for building [Apache Arrow Flight](https://arrow.apache.org/blog/2020/05/06/introducing-arrow-flight/) servers that integrate seamlessly with the [Airport extension](https://airport.query.farm) for [DuckDB](https://duckdb.org/).

This framework enables secure, efficient, and scalable server implementations with features such as authentication, schema management, and predicate pushdown for data queries.

---

## 🚀 Key Features

* ✅ **Authentication & Authorization**: Pluggable backends for secure access control
* 📚 **Schema & Table Management**: Full support for schema evolution and DDL operations
* 📈 **Rate Limiting & Usage Tracking**: Monitor and control client usage
* 🧩 **Extensible & Type-Safe**: Built for safe and scalable extension
* ☁️ **AWS Integration**: Support for S3 storage and DynamoDB-based authentication

---

## 🛰 Arrow Flight Server Support

Designed to simplify the development of Arrow Flight servers:

* Generic, reusable base classes for implementing Arrow Flight endpoints
* Standardized handlers for all major data operations
* Supports both streaming and batch workflows
* Typed parameter parsing and serialization for safer code

---

## 🔐 Authentication System

Unified interface for multiple authentication backends:

* In-memory backend for local development and tests
* DynamoDB backend for scalable, persistent auth
* Naive implementation for prototyping
* Token-based auth with built-in rate limiting

---

## 🔄 Data Serialization

Efficient and type-safe serialization for Airport-compatible servers:

* Parameter serialization using [MessagePack](https://msgpack.org/)
* Record batch transfer using Arrow IPC
* Support for DuckDB expression (de)serialization
* Optimized binary payloads for Arrow Flight actions

---

## 🛠 Admin CLI

Built-in command-line tool for managing and monitoring your server:

* Create and manage user accounts and tokens
* Monitor usage and generate reports
* Manage configuration settings

---

## 🧩 Designed for Extension

Whether you're integrating new storage backends, customizing authentication, or implementing complex business logic, `query-farm-flight-server` is built to scale with your needs while keeping your codebase clean and type-safe.


# Getting Started

Installation

```python
pip install query-farm-flight-server
```

# Development

This python module is designed to be extended for specific database backends. Implement the abstract methods in `BasicFlightServer` to create a custom server for your specific data source.

The project maintains strict type safety through Python's typing system and Pydantic models, ensuring robust API contracts.

## Author

This Python module was created by [Query.Farm](https://query.farm).

# License

MIT Licensed.
postg-q 0.1.2
Minimal PostgreSQL utility with psycopg2

# postg.py

https://pypi.org/project/postg-q/0.1.0/

A minimal PostgreSQL database utility class using `psycopg2` with basic methods for interacting with a PostgreSQL database.

## Features

- Connect to PostgreSQL
- Create tables
- Insert records
- Select records (with optional filters)
- Update records (by condition)
- Delete records (by condition)
- Count rows
- Execute raw SQL queries with parameters

## Requirements

- Python 3.11+
- psycopg2
- python-dotenv (optional, for loading env variables)

## Installation

```bash
pip install postg-q


## Docs

1. Initialize and connect

from postg import DB

db = DB(
    dbname="your_db_name",
    user="your_user",
    password="your_password",
    host="localhost",
    port="5432"
)
db.connect()

2. Create a table

schema = """
CREATE TABLE IF NOT EXISTS users (
    id SERIAL PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT UNIQUE NOT NULL
);
"""
db.create_table(schema)

3. Insert data

db.insert("users", {"name": "Alice", "email": "alice@example.com"})

4. Select data

users = db.select("users")
filtered = db.select("users", {"name": "Alice"})


5. Update records

db.update("users", filters={"name": "Alice"}, data={"email": "new@example.com"})

6. Delete records

db.delete("users", {"email": "new@example.com"})

7. Count rows

total = db.count("users")
filtered = db.count("users", {"name": "Bob"})

8. Run raw SQL queries

# Insert
db.query("INSERT INTO users (name, email) VALUES (%s, %s)", ("John", "john@example.com"))

# Select
result = db.query("SELECT * FROM users WHERE name = %s", ("John",))
filebin-cli 0.3.2
A cli tool to temporarily share file without any hassle. Uses filebin.net public api
Requires Python: >=3.7.9
Keywords: cli, filebin, file-sharing, temporary-files, command line application, click

# 📦 filebin-cli

### A simple and hassle-free CLI tool to **share files temporarily** — upload files directly from your terminal. No login. No setup. Just share the link.

Built with ❤️ in Python, `filebin-cli` is a simple and convenient command-line interface for interacting with the file-sharing service [filebin.net](https://filebin.net).

This tool allows you to upload, download, and manage files and bins directly from your terminal, featuring progress bars, **shortcodes for bin access**, and full bin management capabilities.

## Please refer to docs for quickstarts, usage & command references

---

## 📄 Documentation

### 👉 [filebin-cli Docs](https://github.com/mshirazkamran/filebin-api?tab=readme-ov-file#-filebin-cli)

---
### Note: Please use version 0.3.2 for smooth issue free experience

### Report bugs and issues at [Github issues](https://github.com/mshirazkamran/filebin-api/issues)
---

## 📝 Changelog


### v0.3.2
- Removed deprecated package, pkg_resources

### v0.3.1
- minor updates

### v0.3
- Added integration for **shortcode** to access bins more easily (refer to docs)
- Added archive download commands

### v0.2
- Minor refactoring for improved structure and readability.

---