Click here to Skip to main content
15,895,827 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
honey the codewitch24-Dec-20 9:50
mvahoney the codewitch24-Dec-20 9:50 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
PIEBALDconsult24-Dec-20 10:23
mvePIEBALDconsult24-Dec-20 10:23 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
honey the codewitch24-Dec-20 10:54
mvahoney the codewitch24-Dec-20 10:54 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
PIEBALDconsult24-Dec-20 11:32
mvePIEBALDconsult24-Dec-20 11:32 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
honey the codewitch24-Dec-20 11:45
mvahoney the codewitch24-Dec-20 11:45 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
PIEBALDconsult24-Dec-20 13:17
mvePIEBALDconsult24-Dec-20 13:17 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
honey the codewitch24-Dec-20 13:24
mvahoney the codewitch24-Dec-20 13:24 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
PIEBALDconsult24-Dec-20 14:23
mvePIEBALDconsult24-Dec-20 14:23 
honey the codewitch wrote:
our parsers are fundamentally different


Yes.

I suppose the biggest conceptual difference between ours is that I needed to write a fairly general loader utility which could read a "script" and perform the tasks, not write several purpose-built utilities -- one for each file to be loaded. The ability to have it support CSV (and XML) as well as JSON was an afterthought.

honey the codewitch wrote:
I parse no numbers, no strings, nothing, unless you actually request it.


Well, mine too. It does have to tokenize so it knows when it finds something you want it to parse, but nothing more than that until it finds a requested array.
If the script being run says, "if you find the start of an array named 'Widgets', then do this with it", then the parser has to know "I just found an array named 'Widgets'".

honey the codewitch wrote:
you are normalizing unconditionally at the parser level


Well, I suppose so, insofar as I make values (or names) out of every token, but at that point they're just strings -- name/value pairs with a type -- they're not parsed.
I throw only those strings which we want at the SQL Server and it handles any conversions to numeric or other types, the loader has no say in that.
The loader has no say in data normalization either, it's just passing values as SQL parameters.

Again, I want nearly every value in the file to go to the database, so of course I wind up with every value and throw them all at SQL Server.

It may be a misunderstanding of terms, but in my opinion, no actual "parsing" is done until the (string) values arrive at SQL Server -- that's where the determinations of which name/value pairs go where, what SQL datatype they should be, etc. happens. The loader utility has no knowledge of any of that.
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
honey the codewitch24-Dec-20 15:56
mvahoney the codewitch24-Dec-20 15:56 
GeneralRe: Who here knows what a pull parser or pull parsing is? Pin
honey the codewitch24-Dec-20 16:03
mvahoney the codewitch24-Dec-20 16:03 
AnswerRe: Who here knows what a pull parser or pull parsing is? Pin
User 1493685330-Dec-20 10:25
User 1493685330-Dec-20 10:25 
JokeI'm isolating over Christmas, so... Pin
DerekT-P22-Dec-20 10:23
professionalDerekT-P22-Dec-20 10:23 
GeneralRe: I'm isolating over Christmas, so... Pin
DRHuff22-Dec-20 11:18
DRHuff22-Dec-20 11:18 
GeneralRe: I'm isolating over Christmas, so... Pin
Joe Woodbury22-Dec-20 11:28
professionalJoe Woodbury22-Dec-20 11:28 
GeneralDid I fall asleep for a few months, and it's April 1st? Pin
OriginalGriff22-Dec-20 10:18
mveOriginalGriff22-Dec-20 10:18 
GeneralRe: Did I fall asleep for a few months, and it's April 1st? Pin
DerekT-P22-Dec-20 10:25
professionalDerekT-P22-Dec-20 10:25 
GeneralRe: Did I fall asleep for a few months, and it's April 1st? Pin
OriginalGriff22-Dec-20 10:26
mveOriginalGriff22-Dec-20 10:26 
GeneralRe: Did I fall asleep for a few months, and it's April 1st? Pin
RickZeeland22-Dec-20 19:36
mveRickZeeland22-Dec-20 19:36 
GeneralRe: Did I fall asleep for a few months, and it's April 1st? Pin
Mike Hankey23-Dec-20 2:10
mveMike Hankey23-Dec-20 2:10 
GeneralRe: Did I fall asleep for a few months, and it's April 1st? Pin
dandy7223-Dec-20 5:35
dandy7223-Dec-20 5:35 
GeneralThought of the Day PinPopular
OriginalGriff22-Dec-20 4:35
mveOriginalGriff22-Dec-20 4:35 
GeneralRe: Thought of the Day Pin
W Balboos, GHB22-Dec-20 5:01
W Balboos, GHB22-Dec-20 5:01 
GeneralRe: Thought of the Day Pin
jeron122-Dec-20 5:14
jeron122-Dec-20 5:14 
GeneralRe: Thought of the Day Pin
Daniel Pfeffer22-Dec-20 7:25
professionalDaniel Pfeffer22-Dec-20 7:25 
GeneralRe: Thought of the Day Pin
dandy7222-Dec-20 9:52
dandy7222-Dec-20 9:52 

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.