Databases
StackOverflow2013
Postsdbo
POApplication Architecture For Ease of Application Customization
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POApplication Architecture For Ease of Application Customization
    primarykey
    data
    text
    <p>I'm looking for input on a direction to take for building an accounting application. The application needs to allow for high customization, sometimes entire processes will need to changed.</p> <p>I want a way to make changes without re-compiling the entire application when a customer has a specific modification request. The back-end will be a SQL database of some sort. Most likely SQL Server Express for cost reasons. The front-end will be C#.</p> <p>I'm thinking of an event-based system that will have events for when different types of actions, such as entries, are made. I would then have a plugin system that handles the event. I may need to have multiple processes apply in a specific order to the data before it is finally saved. It will need to trigger other processes as well.</p> <p>I want to keep my base application the same, which works for most customers, but have a graceful way of loading the custom processes that other specific customers have.</p> <p>I'm open to all suggestions. Even if they are thinking of completely different ways of approaching the problem. Our current in-house development talent is .NET and MS SQL Server. I'm not aware of a software pattern that may fit this situation.</p> <p>Additional Info: This isn't a completely blank slate system, it will have functionality that works for a large number of the customers. For various reasons, requirements change based on states and even at the region and town level where customization may be necessary. </p> <p>I'd like to be able to plugin additional pre-compiled modules. When I started looking into possible options, I was imagining an empty handler that I could insert code into through a plugin. So say for example, a new entry is made to the general ledger that raises an event. The handler is called, but the handler's code is coming from a plugin, which may be my original process that fits 80% of the customers. If a customer wants a custom operation, I could add a plugin that completely replaces the original one or have it add an additional post processing step through another plugin after the original runs. Sort of a layering process I guess.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMartin
    1. USMartin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POApplication Architecture For Ease of Application Customization
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POApplication Architecture For Ease of Application Customization
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POApplication Architecture For Ease of Application Customization
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you elaborate on why you don't want to compile? Are you saying you want to be able to plug in additional precompiled modules, or have everything driven by some sort of configuration?
      singulars
      1. POApplication Architecture For Ease of Application Customization
      1. USIan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload