Click here to Skip to main content
15,916,412 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Best place to encrypt passwords Pin
CDP180221-Oct-11 6:59
CDP180221-Oct-11 6:59 
GeneralRe: Best place to encrypt passwords Pin
Wayne Gaylard21-Oct-11 7:13
professionalWayne Gaylard21-Oct-11 7:13 
AnswerRe: Best place to encrypt passwords Pin
Shameel7-Oct-11 2:56
professionalShameel7-Oct-11 2:56 
AnswerRe: Best place to encrypt passwords Pin
Bert Mitton18-Oct-11 7:49
professionalBert Mitton18-Oct-11 7:49 
GeneralRe: Best place to encrypt passwords Pin
jschell18-Oct-11 8:54
jschell18-Oct-11 8:54 
GeneralRe: Best place to encrypt passwords Pin
Bert Mitton18-Oct-11 10:38
professionalBert Mitton18-Oct-11 10:38 
QuestionWhich architecture for a data-extractor Pin
ZioCharles1-Oct-11 2:42
professionalZioCharles1-Oct-11 2:42 
AnswerRe: Which architecture for a data-extractor Pin
jschell1-Oct-11 10:43
jschell1-Oct-11 10:43 
Rephrasing....

What you want to do is the following
1. Query a database
2. Write the results to a file.

Based on that a simple solution is based on the following - the query is a single sql select.

If so then you do the following.
1. The sql statement (select) is read from a configuration source.
2. The database layer sequences through the result set columns using a 'get string' api. It also checks for nulls appropriately.
3. An appropriate text output form is defined. It should be capable of dealing with nulls and things like embedded quotes. I would suggest:
a. Use tab for a delimiter
b. For each string value strip out all tabs, and end of line characters and replace with spaces.
4. You put 1, 2, 3 together to write to the file.

Additional items - I suggest that you allow for a configurable file location and file name.

Trying to generalize to more complex examples is probably pointless. Too much generalization ends up recreating things that already exist such a programming languages and report generators.
AnswerRe: Which architecture for a data-extractor Pin
Aneesh Warrier27-Dec-11 17:02
Aneesh Warrier27-Dec-11 17:02 
QuestionDesign Quandary - v2 Pin
#realJSOP28-Sep-11 2:16
professional#realJSOP28-Sep-11 2:16 
AnswerRe: Design Quandary - v2 Pin
Nagy Vilmos28-Sep-11 2:36
professionalNagy Vilmos28-Sep-11 2:36 
AnswerRe: Design Quandary - v2 Pin
Slacker00728-Sep-11 2:40
professionalSlacker00728-Sep-11 2:40 
AnswerRe: Design Quandary - v2 Pin
GParkings28-Sep-11 8:16
GParkings28-Sep-11 8:16 
GeneralRe: Design Quandary - v2 Pin
#realJSOP28-Sep-11 8:50
professional#realJSOP28-Sep-11 8:50 
QuestionDesign Quandary Pin
#realJSOP28-Sep-11 0:05
professional#realJSOP28-Sep-11 0:05 
AnswerRe: Design Quandary Pin
Pete O'Hanlon28-Sep-11 0:19
mvePete O'Hanlon28-Sep-11 0:19 
GeneralRe: Design Quandary Pin
#realJSOP28-Sep-11 1:22
professional#realJSOP28-Sep-11 1:22 
GeneralRe: Design Quandary Pin
#realJSOP28-Sep-11 2:17
professional#realJSOP28-Sep-11 2:17 
GeneralRe: Design Quandary Pin
Pete O'Hanlon28-Sep-11 3:09
mvePete O'Hanlon28-Sep-11 3:09 
AnswerRe: Design Quandary Pin
Slacker00728-Sep-11 0:20
professionalSlacker00728-Sep-11 0:20 
GeneralRe: Design Quandary Pin
Pete O'Hanlon28-Sep-11 0:26
mvePete O'Hanlon28-Sep-11 0:26 
GeneralRe: Design Quandary Pin
Slacker00728-Sep-11 0:28
professionalSlacker00728-Sep-11 0:28 
GeneralRe: Design Quandary Pin
#realJSOP28-Sep-11 1:26
professional#realJSOP28-Sep-11 1:26 
GeneralRe: Design Quandary Pin
Slacker00728-Sep-11 1:33
professionalSlacker00728-Sep-11 1:33 
GeneralRe: Design Quandary Pin
#realJSOP28-Sep-11 2:17
professional#realJSOP28-Sep-11 2:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.