whichdb

EffiProz

discontinued

by EffiProz · since 2009 · also known as EffiProz Database

Pure C# embedded SQL engine modelled on HSQLDB, with Silverlight and Windows Phone 7 builds; dead since 2012.

relationalembedded libraryopen source (permissive)legacy
Website Compare Find similar

discontinued. Abandoned around 2012; the vendor domain now serves unrelated spam. For embedded .NET use SQLite or LiteDB.

Overview

EffiProz was an embedded relational database written entirely in C#, with an SQL dialect and feature set closely tracking HSQLDB 1.9/2.0. It ran in-process in .NET, Silverlight 4 and Windows Phone 7 applications, shipped an ADO.NET and Entity Framework provider with Visual Studio 2010 designer support, and let developers write stored functions, aggregates and table-valued functions in CLR languages. A Ms-PL community edition lived on CodePlex alongside commercial builds, and the company was a 2010 Red Herring Global 100 winner. Development stopped around 2012; effiproz.com now hosts unrelated spam, so use the archived CodePlex pages for reference. SQLite (Microsoft.Data.Sqlite) or LiteDB cover the same embedded .NET niche today.

Embedded / in-processMobile & offline

Strengths & trade-offs

Strengths

  • +Fully managed C# code: no native binaries, so it ran inside the Silverlight and Windows Phone 7 sandboxes
  • +Rich SQL inherited from HSQLDB, plus CLR user-defined functions, aggregates and TVFs
  • +Entity Framework provider and Visual Studio 2010 tooling

Trade-offs

  • −Dead since about 2012; targets platforms (Silverlight, WP7) that are themselves gone
  • −Original site and source host have disappeared
  • −Small user base; little documentation survives

Great for

  • +Historical reference for managed-code embedded SQL engines
  • +Maintaining very old Silverlight or WP7 apps that bundled it

Think twice for

  • −New .NET applications
  • −Multi-user server deployments

Capabilities

Native or official first-party support · 8 of 25 tracked

✓Transactions
✓Joins
✓Secondary indexes
✓Triggers
✓Stored procedures
✓In-memory
✓Durable persistence
✓Role-based access
–Full-text search
–Vector search
–Geospatial
–JSON
–Change data capture
–Materialized views
–TTL / expiry
–Pub/Sub
–Columnar storage
–Compression
–Encryption at rest
–Time travel
–Branching
–Online schema changes
–Streaming ingest
–Offline sync
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Small · ≤ 100 GB
Horizontal scaling
None
Multi-region
No
Transactions
Full ACID
Consistency
Strong
Schema
Strict
Architecture
Embedded
Query languages
SQL (HSQLDB-style)

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

Ecosystem

apis & protocolsADO.NET, Entity Framework provider
client languagesC#, VB.NET

Alternatives to EffiProz

Compare all→
SQLiteRelational75.5

The in-process SQL engine that ships in every phone, browser and OS: one file, zero servers.

effiproz vs sqlite →
LiteDBDocument10.8

Serverless single-file NoSQL document database for .NET, in the spirit of SQLite.

effiproz vs litedb →
HyperSQL (HSQLDB)Relational9.4

Long-running pure-Java SQL database with strong SQL:2023 coverage, used embedded and in LibreOffice.

effiproz vs hsqldb →
Realm (Atlas Device SDK)Object25.2

Object-oriented mobile database whose MongoDB sync service is gone; the local engine survives as open source.

effiproz vs realm →
PowerSyncRelational23.3

Sync engine that keeps on-device SQLite in sync with Postgres, MongoDB, MySQL or SQL Server.

effiproz vs powersync →
InterBaseRelational18.3

Embarcadero's small-footprint SQL database for servers and embedded apps, with built-in AES encryption.

effiproz vs interbase →

EffiProz FAQ

What is EffiProz?

EffiProz is a relational database by EffiProz, first released in 2009. EffiProz was an embedded relational database written entirely in C#, with an SQL dialect and feature set closely tracking HSQLDB 1.9/2.0. It ran in-process in .NET, Silverlight 4 and Windows Phone 7 applications, shipped an ADO.NET and Entity Framework provider with Visual Studio 2010 designer support, and let developers write stored functions, aggregates and table-valued functions in CLR languages. A Ms-PL community edition lived on CodePlex alongside commercial builds, and the company was a 2010 Red Herring Global 100 winner. Development stopped around 2012; effiproz.com now hosts unrelated spam, so use the archived CodePlex pages for reference. SQLite (Microsoft.Data.Sqlite) or LiteDB cover the same embedded .NET niche today.

Is EffiProz open source?

Yes. EffiProz is open source. License: Microsoft Public License (community edition); commercial editions.

Does EffiProz support ACID transactions?

Yes. EffiProz supports full ACID transactions, with strong consistency.

Does EffiProz scale horizontally?

EffiProz does not scale horizontally; it runs on a single node, so you scale it up rather than out. It is comfortable at small scale (≤ 100 GB).

How can I run EffiProz?

You can self-host it and embed it in your application.

What is EffiProz best for?

EffiProz is a strong fit for historical reference for managed-code embedded SQL engines and maintaining very old Silverlight or WP7 apps that bundled it. Think twice for new .NET applications.

What are the best alternatives to EffiProz?

Common alternatives to EffiProz include SQLite, LiteDB, HyperSQL (HSQLDB), Realm (Atlas Device SDK) and PowerSync. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

Is EffiProz still maintained?

EffiProz is discontinued. Abandoned around 2012; the vendor domain now serves unrelated spam. For embedded .NET use SQLite or LiteDB.

How popular is EffiProz?

EffiProz has little measurable public adoption today, so it ranks near the bottom of the WhichDB Score.