c# - .NET, JSON, Embedded, Free Commercial-Use data management solution? What to do? -

-

i trying develop data management solution commercial product meets several criteria. criteria , reasoning follows:

  1. the solution should in c# or support c#
  2. manage data json
  3. no external schema maintenance
  4. be able cache or data in memory , persist disk
  5. not require additional installation
  6. if solution involves third-party software, license must support no-cost commercial use

requirement #1: application written in c# , prefer solution not involve integrating applications, libraries, or code in language.

requirement #2: there several json-based tools , libraries utilize, need solution data either in or converts to/from json.

requirement #3: want avoid schema maintenance comes using relational database solutions. prefer manage mismatched data-to-object mappings in code , have code update older data instead of managing schema updates separately.

requirement #4: require or data loaded memory @ times, , data persisted disk. whether data persists in memory or not should optional per data type.

requirement #5: when installing product don't want have secondary installations or have external services running other application. self-contained solution best.

requirement #6: intended use distributed commercial product. prefer avoid additional fees or licensing issues come many third-party solutions.

to date have tried several solutions. did not have many constraints , went sqlite.net , use wasn't unpleasant, overhead schema maintenance , data format more like. investigated lot of nosql solutions (such ravendb), other third-party solutions (karvonite), , simple json file storage implementations, i'm not satisfied of them.

is there custom approach or solution missing, else has used successfully? i'm hoping overlooking option(s) after, , nosql , .net experts out there have enough experience in area point me in right direction.

edit: in case original commentators confused, updated question , title better adhere so's policies.

fluent nhibernate automapping on top of sqlite meet requirements except edit #2 - "nosql, preferably data json document"

it automaps relational db schema object model...does not use json. edit might able save json data blob, however. (caveat: know nothing json)


Comments

Post a Comment

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

-
i'm trying subclass qstyleditemdelegate remove focus rectangle in qcombobox . even though i'm calling base implementation of paint function , nothing else, result different. looks if parts of style-sheet influence bounding box of item taken consideration. class pstyleditemdelegate(qstyleditemdelegate): def __init__(self, *args, **kwds): super(pstyleditemdelegate, self).__init__(*args, **kwds) def paint(self, *args, **kwargs): qstyleditemdelegate.paint(*args, **kwargs) what have paint unmodified qstyleditemdelegate ? as suggested tried replacing pyside pyqt4 , works, appears bug. update pyside 1.1.2 1.2.1 result same. unfortunately switch breaks other parts of code, if there no other suggestions i'm going accept answer. edit bug tracked here
Read more

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

-
i have used httpclient3.1(java) connection pooling below : import org.apache.commons.httpclient.httpclient; import org.apache.commons.httpclient.multithreadedhttpconnectionmanager; import org.apache.commons.httpclient.params.httpclientparams; import org.apache.commons.httpclient.params.httpmethodparams; import org.apache.log4j.logger; public class httpclientmanager { private static logger logger = logger.getlogger(httpclientmanager.class); private static multithreadedhttpconnectionmanager connectionmanager = new multithreadedhttpconnectionmanager(); private static httpclientparams clientparams = new httpclientparams(); static { try { clientparams.makelenient(); clientparams.setauthenticationpreemptive(false); clientparams.setparameter(httpmethodparams.so_timeout, new integer(30000)); // set so_timeout clientparams.setparameter(httpmethodparams.head_body_check_timeout, new integer(3000)); // head responses
Read more

SQL: Divide the sum of values in one table with the count of rows in another -

-
is possible to, in single query, sum bunch of values in 1 table, , divide count of rows in another? there common id/key in both tables... fyi, win points least info provided in question. answer it's possible...here psuedo code since i'm guessing @ tables , columns select summing / counting whynot (select id, sum(whatever) summing where_ever ) inner join (select id, count(1) counting what_ever)b on a.id = b.id question = 'vague' group a.id
Read more