search

google-code-export / sqljet

Automatically exported from code.google.com/p/sqljet
0 stars 1 forks source link

import csv files into sqlite #179

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 

Is sqljet supports import csv files into sqlite ?

Original issue reported on code.google.com by jerryal...@gmail.com on 4 Oct 2013 at 8:36

GoogleCodeExporter commented 9 years ago 
No, but you could just parse csv (using any third-party parser or your own) and 
insert your data through sqljet API.

Original comment by sergey.s...@gmail.com on 4 Oct 2013 at 10:57

GoogleCodeExporter commented 9 years ago 
sqlite itself supporting import csv files , it is one of essential feature of 
sqlite.
hey do something for this.

Original comment by jerryal...@gmail.com on 4 Oct 2013 at 12:30

GoogleCodeExporter commented 9 years ago 
sorry, but so far sqljet doesn't support all features of sqlite.

Original comment by sergey.s...@gmail.com on 4 Oct 2013 at 12:32

GoogleCodeExporter commented 9 years ago 
Is sqljet supports group by,order by and aggregate functions

Original comment by jerryal...@gmail.com on 18 Nov 2013 at 5:52

GoogleCodeExporter commented 9 years ago 
No, so far SQLJet doesn't support directly anything more than just reading data 
from SQLite DB file format.
SQLJet can use indexes for ordering records in tables, so it may be as 'ordered 
by' if you have defined appropriate index. Also there are functions in SQLJet 
for search and filter records using indexes. All those operations with indexes 
are very fast and efficient. One aggregate function which defined there is 
'count(*)'. All other more complicated operations and functions you should 
define in your own code over SQLJet API. See http://sqljet.com/tutorial.html 
for sample of API.

Original comment by sergey.s...@gmail.com on 18 Nov 2013 at 11:59