Paul McGuire4d ago
If you're going to PyConUS and planning out your talk schedule, I scraped the website talks and saved the title, times, room, speaker, and description into a CSV. You can find it in this Github gist (https://gist.github.com/ptmcg/d851232d6b90812e1c01c990ecec516c), which uses littletable and rich packages to provide a simple REPL to search the talks by keyword, title, and speaker. #pycon #pyconus #python #littletable
Paul McGuireNov 19, 2024
Well I have this Medium account and never posted anything on it, so I decided to write up my littletable project. littletable was an experiment in ORMs that I started about 15 years ago, but it has really come in handy in dealing with small data sets and CSVs (up to a few thousand items). https://medium.com/@ptmcg/data-in-the-small-python-package-littletable-combines-in-memory-nosql-orm-with-schemaless-setup-54ea0b24ac6a #python #orm #database #littletable
Data in the Small: Python package littletable combines in-memory NoSQL ORM with schemaless setup

A number of years ago, I was getting my head around ORMs for accessing databases using an object collection facade, so I wrote a small toy package for myself to wrap a list of Python objects. Iā€¦

Medium
Paul McGuireJul 28, 2024
I just released v3.0.0 of #littletable, a pure Python lightweight alternative to pandas for easy CSV/JSON/Excel import/export, text search, query and pivot for smallish data sets (up to 1MM records or so). Schemaless, littletable works against a list of objects using the object attributes as columns. littletable is compatible with Python 3.9-13. Small installation footprint (single .py file), can be dropped into tight runtime environments. #python #littletable #dataanalysis #dataanalysistools
Paul McGuireJun 8, 2024
Just to report that my 3 open source packages pyparsing, littletable, and logmerger (and by extension, textual, which is used by logmerger) all run successfully on Python 3.13b2 (default build) #python #python313 #pyparsing #littletable #logmerger #textual
Paul McGuireMay 12, 2024
I just posted a new blog entry about my in-memory ORM littletable, and how it supports table indexing using the "by" pseudo-attribute: https://thingspython.wordpress.com/2024/05/12/littletable-api-design-and-the-adapter-factory-pattern/ #python #littletable #database #orm
littletable API Design and the Adapter Factory Pattern

About 14 years ago, while trying to understand the rationale and philosophy behind ORMs and how they are used, I wrote a small in-memory data store package so that I could learn by creating. About ā€¦

Things Python
Paul McGuireJan 22, 2023
Python in a Nutshell, 4th Edition adds an appendix listing new language features (and those removed) for versions 3.7-3.11. I extracted this data into a #littletable for full text search - visit at http://ptmcg.pythonanywhere.com/python_nutshell_app_a_search #python #pynutshell4
Python in a Nutshell 4Ed - Appendix A Search

Show threadPaul McGuireDec 17, 2022
You can query this littletable-powered PEP data set here (http://ptmcg.pythonanywhere.com/pep_search). #python #littletable
Python PEP Abstract Keyword Search

Show threadPaul McGuireNov 9, 2022
@brettcannon It looked like such a great data set, I composed a littletable example for it, to be included in 2.1.1. Here is a gist of that example, along with an expanded peps.json including each PEP's abstract. #python #littletable
skunksarebetterJan 28, 2022

#littletable is a document database for #Python.

littletable is an in-memory database for keyed structures like dictionaries and named tuples. littletable can perform simple match searches, full text searches, joins, and pivots. littletable can both import and export to CSV, as well as display data in a customisable manner.

Website šŸ”—ļø: https://github.com/ptmcg/littletable

#free #opensource #foss #fossmendations #programming

GitHub - ptmcg/littletable: An in-memory database of Python objects, searchable using quasi-SQL API

An in-memory database of Python objects, searchable using quasi-SQL API - ptmcg/littletable

GitHub