{"repo":"rclement/sqlite-ml","free":true,"listed":false,"github":"https://github.com/rclement/sqlite-ml","clone":"git clone https://github.com/rclement/sqlite-ml.git","description":"An SQLite extension for machine learning","language":"Python","stars":55,"topics":["machine-learning","mlops","sql","sqlite"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"sqlite-ml An SQLite extension for machine learning Train machine learning models and run predictions directly from your SQLite database. Inspired by PostgresML. Why? Why bother running Machine Learning workloads in SQLite? Good question! Here are some answers: - Machine Learning number one problem is data - Instead of trying to bring the data to the model, why not bring a model along the data? - Instead of exporting the data some place else, training a model, performing inference and bringing back the prediction into the database, why not do that directly alonside the data? - Lots of ETL/ELT workloads are converging to pure SQL processing, why not do that also with predictions? - The field of MLOps tries to unify the ML lifecycle but this is hard when working on multiple environments - SQLite is fast - The SQLite ecosystem is quite good (take a look at all the wonderful things around Datasette) - SQLite is often used for ad-hoc data analysis, why not give the opportunity to also make predictions at the same time? - Easy to integrate predictions for existings applications, use a simple SQL query! Install pip install sqlite-ml Warning Currently, the only way to load this extension is through Python SQLite3 : We are working on making this extension a native SQLite extension, usable within any SQLite context, stay tuned! In any case, the easiest ways to get started with sqlite-ml is to use either: - The Datasette plugin datasette-ml - The SQLite-Utils plugin sqlite-utils-ml Tutor","default_branch":null,"files":null,"tree":[],"storefront":"/r/rclement","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/rclement/sqlite-ml/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."}