architecture - Should you store current application state in a database? -

-

i have started working on project postgres database used integral component in system architecture. has forced me abandon previous notions database well, store things.

there api translates incoming requests database queries/updates. causes triggers in database notify application update actual system accordingly.

to me seems unnecessary. in system critical architecture, , yet have no way guarantee knowledge of underlying systems failure making chain since async. in short don't @ all. view should restart scratch using direct communication between api , underlying system, using database store persistant state updates / user information etc.

what i'm looking here explain me why i'm wrong before end falling out team, views welcome.

the reason support such integration low cost, if 2 integrated systems uses own proprietry technologies comminucating bad each other. also, db integration presents old style of integration.

what want acheive (or @ least increase) called "autonomy". big topic talk about, i'll try highlight important things according situation.

  1. triggers , stored procedures evil. leads "logic leak" db , hence results in bad portability , maintainability of busines logic , whole app. thing stored procedures may usefull increasing of performance. there many ways tune performance without them.
  2. as applications connected via db dealing tight coupling between them, tightly depend on each other , hence maintainability , reusability of both applications suffer.
  3. by connecting of applications via db in complex manner may stuck scaling in future.
  4. using db solution invokation of dealing coupling technology, not designed that. it's bad because of inflexibility , possible future limitations. more poorly if non-standardized of proprietary tools , protocols used.

today (enterprise) best practice in using of autonomous applications application (not integration) non-shared database, communicating via standardized protocol, through reliable middleware. more expensive provides lots of benefits (scalability, maintainability, flexibility, etc).

to decide if should rewrite something, @ first need estimate costs , benefits. if big legacy tightly coupled composition works fine, it's better way not touch it, create facade-like wrapper if needed.

finally,

what i'm looking here explain me why i'm wrong

i don't think wrong.


Comments

Post a Comment

Popular posts from this blog

javascript - how to protect a flash video from refresh？ -

-
<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>flash video refresh</title> </head> <body> <div id="playerzone"><embed height="496" width="580" flashvars="flvid=19742822&amp;createtime=2012-4-19 13:46:33" wmode="opaque" allowscriptaccess="always" allowfullscreen="true" quality="high" bgcolor="#000000" name="player" id="player" src="swf/mine.swf" type="application/x-shockwave-flash"></div> <a onclick="return test();" id="test">click me popup div,and hide scrollbar</a> </body> the code upon： for example,when click a#test button,popup div,it's no problem,but want hide scrollbar while div popup. i used $('html').css('overflow','hidden') in...
Read more

visual studio 2010 - Connect to informix database windows form application -

-
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working. i have installed latest sdk ibm informix. i have included ibm.data.informix.dll references in project. i have included using ibm.data.informix; i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened." this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory. my on click code is private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = ...
Read more

android - Associate same looper with different threads -

-
Image
in application, want create multiple threads working on single queue. create queue know need call looper.prepare() . i want other threads create should associated looper created first thread, how can achieve this? use 1 of java thread safe queue class java.util.concurrent package instead of looper achieve goal. it's more common practice. share queue between threads , post task queue entry 1 thread can entry thread. blockingqueue can - in 1 thread call take() , block thread until thread put() entry queue. that's all. producer consumer pattern example blockingqueue or concurrentlinkedqueue about blockingqueue
Read more