[sqlite] sqlite fixed data loading extension

Well, like I mentioned, I do have the basic functionality that I want in an existing C# application. Unfortunately it works in the opposite direction that I was hoping...meaning it implements Sqlite and not Sqlite implementing it. The functionality would be more generally usable if Sqlite could

[sqlite] sqlite fixed data loading extension

On Fri, 25 Mar 2016 06:49:22 -0500 Don V Nielsen wrote: > I have a need for something that can parse and load into sqlite tables > fixed length data. Insert your own separators. $ cat input 12345678910111213141516171819202122232425 Print two 5-byte ranges separated by ", ". $ awk '{

[sqlite] sqlite fixed data loading extension

On Fri, Mar 25, 2016 at 12:49 PM, Don V Nielsen wrote: > > (I guess this begets the question..."Is sqlite's csv import an extension?") No, it is not an extension, it's part of SQLite's shell directly: https://www.sqlite.org/cli.html#csv Which also means it's not part of the SQLite library

[sqlite] sqlite fixed data loading extension

> > ??I have a need for something that can parse and load into sqlite tables > fixed length data. ?All the applications I have had experience with in the past (Sqlite Expert, > Navicat, and some others) require the user to run an application and setup > the functionality each and every time you

[sqlite] sqlite fixed data loading extension

I have a need for something that can parse and load into sqlite tables fixed length data. I know sqlite has a csv import, so I would like to duplicate that kind of functionality handling fixed columnar data. I thought an extension would be perfect so I could specify something as simple as "sqlite3