{"library":"sqlalchemy-citext","title":"SQLAlchemy CIText","type":"library","description":"A SQLAlchemy plugin that provides CITEXT (case-insensitive text) support for PostgreSQL. The latest version is 1.8.0, with infrequent releases as needed.","language":"python","status":"active","last_verified":"Mon Apr 27","install":{"commands":["pip install sqlalchemy-citext"],"cli":null},"imports":["from sqlalchemy_citext import CIText","from sqlalchemy_citext.types import CITextComparator"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/mahmoudimus/sqlalchemy-citext","docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlalchemy-citext/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"from sqlalchemy import create_engine, Column, Integer, String\nfrom sqlalchemy.ext.declarative import declarative_base\nfrom sqlalchemy_citext import CIText\n\nBase = declarative_base()\n\nclass User(Base):\n    __tablename__ = 'users'\n    id = Column(Integer, primary_key=True)\n    name = Column(CIText)\n\nengine = create_engine('postgresql://user:pass@localhost/db')\nBase.metadata.create_all(engine)\n\n# Insert and query case-insensitively\nfrom sqlalchemy.orm import sessionmaker\nSession = sessionmaker(bind=engine)\nsession = Session()\nsession.add(User(name='Alice'))\nsession.commit()\nuser = session.query(User).filter(User.name == 'alice').first()  # works\nprint(user.name)  # Alice","lang":"python","description":"Example using CIText with SQLAlchemy ORM.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}