{{Quickfixn}} Does QuickFIX/N support logging to databases?
Mike Gatny
mgatny at connamara.com
Tue Jan 22 08:40:04 PST 2019
Mark,
Here's a recent example of porting a database store implementation (though
not db log in this case), which gives an idea of the things that need to be
addressed: https://github.com/quickfixgo/quickfix/pull/90/files
Specifically, here's the steps I followed when porting the db store to
qf/go:
1. Ported the sql scripts that create the db tables (I borrowed these
almost directly from qf/c++)
2. Ported the new SessionSettings (I borrowed a blend of the qf/c++ and
qf/j implementation)
3. Ported the unit tests. For the qf/go port, I was able to simply reuse
the existing generic store_test.go suite
<https://github.com/quickfixgo/quickfix/blob/master/store_test.go> (golang's
test framework makes this very easy). It's nicely commented and would make
a good basis for your unit tests.
4. Ported the actual impl (again a blend of qf/c++ and qf/j impl) to get
those tests passing. Examples: JdbcLog
<https://github.com/quickfix-j/quickfixj/blob/master/quickfixj-core/src/main/java/quickfix/JdbcLog.java>
, JdbcLogFactory
<https://github.com/quickfix-j/quickfixj/blob/master/quickfixj-core/src/main/java/quickfix/JdbcLogFactory.java>,
MySQLStore.cpp
<https://github.com/quickfix/quickfix/blob/master/src/C%2B%2B/MySQLStore.cpp>
5. Updated the configuration documentation (i.e. SessionSettings). You
can see the correspond qf/go settings here
<https://www.quickfixgo.org/docs/configuration.html#Storage> and the
corresponding qf/j settings here
<https://quickfixj.org/usermanual/2.1.0/usage/configuration.html#Storage>.
Note that since both are db-agnostic, both provide a setting for choosing
the desired Driver (e.g. postgres).
--
Mike Gatny
Connamara Systems
On Fri, Jan 18, 2019 at 1:04 PM Mark Johnson <mark.johnson at finbourne.com>
wrote:
> Hello – does QuickFIX/N support [logging] and [file storage] to databases
> such as Postgres as an alternative to simply writing to disk by setting the
> FileStorePath and FileLogPath configuration options please?
>
>
> ------------------------------
> [image: FINBOURNE Technology - Liberate. Simplify. Connect.]
> <https://www.finbourne.com>
>
> *Mark Johnson*
> FINBOURNE Technology Limited
> 41 Luke Street, London, EC2A 4DP
> www.finbourne.com
>
>
>
> PLEASE READ: The information contained in this e-mail is confidential and
> intended for the named recipient(s) only. If you are not an intended
> recipient of this e-mail you must not copy, distribute or take any further
> action in reliance on it and you should delete it and notify the sender
> immediately. E-mail is not a secure method of communication and FINBOURNE
> Technology Limited cannot accept responsibility for the accuracy or
> completeness of this message or any attachment(s). FINBOURNE Technology
> Limited, registered in England and Wales, company number 10539696. The
> registered office is The Rise Building, 41 Luke Street, London, United
> Kingdom, EC2A 4DP.
> _______________________________________________
> Quickfixn mailing list
> Quickfixn at lists.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/20190122/ec08aa5f/attachment.htm>
More information about the Quickfixn
mailing list