Serialization should be trivial in whatever language you happen to be using. Something along the lines of golang's encoding/gob is ideal for this. In c# there is, no doubt, very robust serialization built in and it really amounts to little more than Serialize(object) <--> Deserialize(object). It is best to have a separate column whose purpose is only to give a version number of some sort to the data. Somebody will then be responsible for tracking any changes to the stored data with different version numbers and, if required, write a simple method for transforming one set of data to another. This does, of course, potentially affect logic within your application, but how to deal with that is up to you.
On Sun, Apr 26, 2015 at 6:13 AM, Jim Callahan < jim.callahan.orlando at gmail.com> wrote: > Does the data from the network analyzer have a datetime stamp? > On Apr 25, 2015 3:45 PM, "Drago, William @ CSG - NARDA-MITEQ" < > William.Drago at l-3com.com> wrote: > > > > -----Original Message----- > > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > > > users-bounces at mailinglists.sqlite.org] On Behalf Of Scott Hess > > > Sent: Friday, April 24, 2015 3:19 PM > > > To: General Discussion of SQLite Database > > > Subject: Re: [sqlite] Thoughts on storing arrays of complex numbers > > > (Solved) > > > > > > On Fri, Apr 24, 2015 at 12:01 PM, Drago, William @ CSG - NARDA-MITEQ > > > <William.Drago at l-3com.com> wrote: > > > > Since the data is received from the analyzer as an array of > > > > real/imaginary pairs (R,I,R,I,R,I,R,I...), 3202 elements total, > > > that's > > > > how I will blob and store it. This is the simplest way to add it to > > > > the database. It's just one more field along with all the other data. > > > > If I ever need to operate on that trace data again it's a simple > > > > matter of pulling out of the database and un-blobbing it. > > > > > > In a case like this, I don't think I've ever come to regret suggesting > > > the use of a serialization library, like protobuf (or cap'n proto or > > > third or avro or ...). When you make your ad-hoc serialization > > > strategy, it works swell for six months, then a new requirement comes > > > downstream and you have to figure out a new format plus how to convert > > > all the old data. If that happens two or three times, you start to get > > > a combinatoric problem which makes it hard to reason about how a change > > > is going to affect existing installs. Most such requirements are for > > > an additional field per array index, which many serialization libraries > > > can support pretty transparently. > > > > So, serialize the complex array data then store it in SQLite as a blob? > > I'm working in C# which has built-in support for serialization, do I > still > > need a third party library? Other than writing some objects to disk in > Java > > quite a few years ago, I have little experience with serialization, sorry > > for the ignorance. > > > > -- > > Bill Drago > > Senior Engineer > > L3 Narda-MITEQ > > 435 Moreland Road > > Hauppauge, NY 11788 > > 631-272-5947 / William.Drago at L-3COM.com > > > > > > > > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any > > attachments are solely for the use of the addressee and may contain > > information that is privileged or confidential. Any disclosure, use or > > distribution of the information contained herein is prohibited. In the > > event this e-mail contains technical data within the definition of the > > International Traffic in Arms Regulations or Export Administration > > Regulations, it is subject to the export control laws of the > > U.S.Government. The recipient should check this e-mail and any > attachments > > for the presence of viruses as L-3 does not accept any liability > associated > > with the transmission of this e-mail. If you have received this > > communication in error, please notify the sender by reply e-mail and > > immediately delete this message and any attachments. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
