{"repo":"ppml38/icecoal","free":true,"listed":false,"github":"https://github.com/ppml38/icecoal","clone":"git clone https://github.com/ppml38/icecoal.git","description":"Lightweight SQL database","language":"Python","stars":15,"topics":["sql","lightweight","lightweight-sql-database","csv-parser","csv-files","csv-sql","icecoal","database","dbms","python"],"license":"MIT","category":"databases-storage","readme_excerpt":"Icecoal Icecoal is a light weight SQL database Targets are, - Apps that require SQL DB or external DB server - Apps that need lightweight replacement for oracle, MySQL etc.., which they use just to store and retrieve data - Those who want to add a database in their app without worrying about any technical jargons such as JDBC, ODBC, Connection driver etc.. - Those who want to conveniently process CSV files with SQL. Features: - Written purely in python - Light weight (Just 57 Kb in total) - No external dependencies - Easy to add in your app/system (Just import!) Demo In action Create a Database Create a table Insert a row in a table Update a row in a table Delete a row in a table Select rows from a table Truncate a table Drop a table Drop a database Processing csv files with SQL How to install Usage General database operations Example Processing your csv data files Here icecoal expects first line of csv file to be header line. if it is not, you can either add headers in first line or create a new file just with headers delimited with comma and add it along with data file name in the query as below Example Change delimiters other than comma This feature is to expand users ability to process files that are delimited with chatacters other than comma. setdel() function will make further calls to query function to interpret data file as custom delimited (which is given by setdel() parameter) Get current default delimiter getdel() function will return current delimiter which is use","default_branch":null,"files":null,"tree":[],"storefront":"/r/ppml38","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ppml38/icecoal/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."}