DEV
Dev Notes
Alopex DB v0.8.16: Performance Compared with Other Products
A fixed-case performance comparison of Alopex DB v0.8.16 DataFrame, SQL, KV, and HNSW operations against Polars, SQLite, PostgreSQL, DataFusion, LMDB, hnswlib, and Faiss HNSW.
Posts tagged#Python
View
BUILD
In-house Development
Alopex DB v0.8.16 Tutorial, Part 5: Opening the Database with a Server
Open an embedded data directory with alopex-server, run the same SQL over HTTP, and read the server-written row through the file API.
BUILD
In-house Development
Alopex DB v0.8.16 Tutorial, Part 4: Vector Search and DataFrames
Store embedding vectors with articles, combine similarity search with SQL filters, and reshape the results with DataFrames in Python and Rust.
BUILD
In-house Development
Alopex DB v0.8.16 Tutorial, Part 3: CASE, Set Operations, CTEs, and Window Functions
Use CASE expressions, UNION and other set operations, common table expressions, rankings, and running totals in Alopex DB.
BUILD
In-house Development
Alopex DB v0.8.16 Tutorial, Part 2: Querying Articles with SQL
Create a table and query it with SELECT, JOIN, aggregation, and subqueries, then combine SQL and key-value data in one transaction.
BUILD
In-house Development
Alopex DB v0.8.16 Tutorial, Part 1: Storing Keys and Values
Install Alopex DB v0.8.16 and learn its key-value API, transactions, deletion, and persistent storage in Python and Rust.
DEV
Dev Notes
Deep Insights into Nim Syntax — How Similar Is It to Pascal, Python, and Haskell?
A 38-topic analysis of Nim syntax — declarations, the type system, expression orientation, generics, distinct types, macros, and compile-time execution — comparing how closely each construct resembles the styles of Pascal, Python, C-family, and functional languages, with a primer on block syntax design and the off-side rule.
DEVBUILDBUILDBUILDBUILDBUILDDEV
Alopex DB v0.8.16: Performance Compared with Other Products
A fixed-case performance comparison of Alopex DB v0.8.16 DataFrame, SQL, KV, and HNSW operations against Polars, SQLite, PostgreSQL, DataFusion, LMDB, hnswlib, and Faiss HNSW.
Alopex DB v0.8.16 Tutorial, Part 5: Opening the Database with a Server
Open an embedded data directory with alopex-server, run the same SQL over HTTP, and read the server-written row through the file API.
Alopex DB v0.8.16 Tutorial, Part 4: Vector Search and DataFrames
Store embedding vectors with articles, combine similarity search with SQL filters, and reshape the results with DataFrames in Python and Rust.
Alopex DB v0.8.16 Tutorial, Part 3: CASE, Set Operations, CTEs, and Window Functions
Use CASE expressions, UNION and other set operations, common table expressions, rankings, and running totals in Alopex DB.
Alopex DB v0.8.16 Tutorial, Part 2: Querying Articles with SQL
Create a table and query it with SELECT, JOIN, aggregation, and subqueries, then combine SQL and key-value data in one transaction.
Alopex DB v0.8.16 Tutorial, Part 1: Storing Keys and Values
Install Alopex DB v0.8.16 and learn its key-value API, transactions, deletion, and persistent storage in Python and Rust.
Deep Insights into Nim Syntax — How Similar Is It to Pascal, Python, and Haskell?
A 38-topic analysis of Nim syntax — declarations, the type system, expression orientation, generics, distinct types, macros, and compile-time execution — comparing how closely each construct resembles the styles of Pascal, Python, C-family, and functional languages, with a primer on block syntax design and the off-side rule.