Install & Compatibility
Where this runs
tested against v1.8.0 · pip install
no network on importno background threads
Install × environment matrix
Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux
muslpy 3.10–3.95 runs
installs and imports cleanly · install 0.0s · import 0.000s · 44.3MB
glibcpy 3.10–3.95 runs
installs and imports cleanly · install 4.3s · import 0.000s · 42MB
42MB installed
● package 42MB
Code
Verified usage
Verified import paths — ran on the pinned version, not inferred.
CIText
✓ from citext import CIText
✗ from sqlalchemy_citext import CIText
Example using CIText with SQLAlchemy ORM.
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy_citext import CIText
Base = declarative_base()
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(CIText)
engine = create_engine('postgresql://user:pass@localhost/db')
Base.metadata.create_all(engine)
# Insert and query case-insensitively
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
session = Session()
session.add(User(name='Alice'))
session.commit()
user = session.query(User).filter(User.name == 'alice').first() # works
print(user.name) # Alice
Upgrade
Version history
1.8.0latest on PyPI · released Mar 2, 2021
Audit
Dependencies
sqlalchemyrequiredCore dependency for database interaction
psycopg2-binaryoptionalPostgreSQL driver