{{Quickfixn}} how to store the FIX message into the database

[Walter Robert Ditzler]

Hi,

 

well i dont know your programming skill, but if you need ms sql 2005 or the
more recent 2012 then better go to:

database:

 <http://www.microsoft.com/en-us/sqlserver/default.aspx>
http://www.microsoft.com/en-us/sqlserver/default.aspx

serialize json

 <http://www.nuget.org/packages/eventstore.serialization.json>
http://www.nuget.org/packages/eventstore.serialization.json

 

 

we love to work in the object oriented way, especially with JSON

database:

 <http://www.mongodb.org> www.mongodb.org

 <http://www.couchbase.com> www.couchbase.com

 

we prefer couchbase since it's got in-memory db functionalities

 

but in this list we can help you only how to handle qfn but we can't help
you what db you need or how you're store data into a db. That should be your
part as a programmer. The qfn data can be stored everywhere you like. One of
my project even uses a flat file store to avoid db over heads.

 

If you're a c# programmer I also would consider to have a look at the TPL

 

 <http://msdn.microsoft.com/en-us/library/dd537609(v=vs.110).aspx>
http://msdn.microsoft.com/en-us/library/dd537609(v=vs.110).aspx

 

to make the app more responsive and faster, in case you're fix feed sends
you too much data at once.

 

Thanks,

 

Walter.

 

 

 

 

 

 

From: quickfixn-bounces at lists.quickfixn.com
[mailto:quickfixn-bounces at lists.quickfixn.com] On Behalf Of vishvesh raval
Sent: Montag, 2. Dezember 2013 11:36
To: Mailing list for QuickFIXn
Subject: Re: {{Quickfixn}} how to store the FIX message into the database

 

hi walter, 

       sorry that i posted the question in wrong list. I am new to these
things.can you please guide me or give me link for the correct list to post
the question.I will be very grateful to you for your help.I really need help
in this matter.Sorry for your inconvenience.

 

 

 

Thanks & Regards,

Vishwesh Raval.

  _____  

CC:  <mailto:quickfixn at lists.quickfixn.com> quickfixn at lists.quickfixn.com
From:  <mailto:ditwal001 at gmail.com> ditwal001 at gmail.com
Date: Mon, 2 Dec 2013 09:20:50 +0100
To:  <mailto:quickfixn at lists.quickfixn.com> quickfixn at lists.quickfixn.com
Subject: Re: {{Quickfixn}} how to store the FIX message into the database

hi,

 

i dont know if this is the right list for that queston! basicly what do u
want to store? everything then go into "fromapp" qfn event or specific qfn
data then use one of the qfn message event's.

 

for the data and compatibility we store it as a serialized json object in a
oodb. if u need to use relational db then maybe use one column for the
serialized string and other designed colums for ur search criterias since
search ops on char is a overhead ops.

 

for the database personally we use mem cache base document store "couch
base" or "mongodb". it depends on what speed you need or interval the fix
data is comming in onto your end.

 

but i guess there are much better list out there to answer u that question.

thx

 

walter.


On 02 Dec 2013, at 06:54, vishvesh raval <
<mailto:vishveshraval at hotmail.com> vishveshraval at hotmail.com> wrote:

hi sir,

  i have one query about quickfix messages.i will be very grateful if you
give your valuable guidance to me.

                                     I want to know that how to store the
FIX message into the database to keep the log of the transferring message in
sql server 2005. Is it to store whole message into the single column of the
table or store the whole message in the Tag value format i.e. column names
should be tag names or tag values and actual transferring message values in
the row. can anyone give me suggestion on it. Thanks in advance.

 

 

 

Thanks & Regards,

Vishwesh Raval

_______________________________________________
Quickfixn mailing list
 <mailto:Quickfixn at lists.quickfixn.com> Quickfixn at lists.quickfixn.com
 <http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com>
http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com


_______________________________________________ Quickfixn mailing list
<mailto:Quickfixn at lists.quickfixn.com> Quickfixn at lists.quickfixn.com
<http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com>
http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.quickfixn.com/pipermail/quickfixn-quickfixn.com/attachments/20131202/8803a5e0/attachment-0002.htm>