{"repo":"ptmcg/littletable","free":true,"listed":false,"github":"https://github.com/ptmcg/littletable","clone":"git clone https://github.com/ptmcg/littletable.git","description":"An in-memory database of Python objects, searchable using quasi-SQL API","language":"Python","stars":179,"topics":["python","database","data-analysis-python"],"license":"MIT","category":"databases-storage","readme_excerpt":"littletable - a Python module to give ORM-like access to a collection of objects - Introduction - Optional dependencies - Importing data from CSV files - Tabular output - For More Info - Sample Demo Introduction ------------ The littletable module provides a low-overhead, schema-less, in-memory database access to a collection of user objects. littletable Tables will accept Python dict s or any user-defined object type, including: - namedtuples and typing.NamedTuples - dataclasses - types.SimpleNamespaces - attrs classes - PyDantic data models - traitlets littletable infers the Table's \"columns\" from those objects' dict , slots , or fields mappings to access object attributes. If populated with Python dict s, they get stored as SimpleNamespace s. In addition to basic ORM-style insert/remove/query/delete access to the contents of a Table , littletable offers: simple indexing for improved retrieval performance, and optional enforcing key uniqueness access to objects using indexed attributes direct import/export to CSV, TSV, JSON, and Excel .xlsx files clean tabular output for data presentation simplified joins using \"+\" operator syntax between annotated Table s the result of any query or join is a new first-class littletable Table simple full-text search against multi-word text attributes access like a standard Python list to the records in a Table , including indexing/slicing, iter , zip , len , groupby , etc. access like a standard Python dict to attributes with a unique index","default_branch":null,"files":null,"tree":[],"storefront":"/r/ptmcg","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ptmcg/littletable/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}