Home

MemPOI 📗 ➡️ 👺 ➡️ 🍹

A library to simplify export from database to Excel files using Apache POI

No ORM = Super Fast

MemPOI is not designed to be used with an ORM due to performance needs on massive exports. By directly leveraging JDBC classes to access DB data, MemPOI ensures super-fast execution on hundreds of thousands of records.

A short story about Mempoi birth

Support

• Apache POI 4.0.0+
• Java 8+

Supported SQL data types

• BIGINT
• DOUBLE
• DECIMAL
• FLOAT
• NUMERIC
• REAL
• INTEGER
• SMALLINT
• TINYINT
• CHAR
• NCHAR
• VARCHAR
• NVARCHAR
• LONGVARCHAR
• TIMESTAMP
• DATE
• TIME
• BIT
• BOOLEAN
• UUID (Postgres) (thanks to nanshakov)

---

You have to take care to manage your database connection, meanwhile PreparedStatement and ResultSet are managed and closed internally by MemPOI

---

Diagrams

Here you can find a set of diagrams describing the MemPOI flow.

--

Special thanks

Special thanks to Colle der Fomento that inspired MemPOI name with their new, fantastic, yearned LP, in particular with their song Mempo.

Don't you know what I'm talking about? Discover what a mempo is!