antlr-tsql VS ActivityLog2

I'm currently working on a TSQL parser in Racket because I want to do some code analysis on a few huge stored proc files (some of which are over 30k lines of code). I didn't want to use existing parsers because the trees they produce are monstrous [1,2]. Tried doing some fancy grep work, but it was giving me way too many false matches and wasn't as sound as I would have liked.

I could use any language with reasonable parsing tools, but I like how flexible Racket is about it. Currently using megaparsack[3], but there are many different parsing tools available depending on your needs. Also, once you have done parsing, there are lots of convenient ways to manipulate the parse trees into whatever shape you need.

I also think Racket has a lot of tooling that would make it great for large code bases.

-It has great offline docs (scribble) which don't force you to use some comment based system like JavaDoc.

-It has a very powerful and fast contract system that can be attached either at definition time like most languages or only at module boundaries.

- While it has a macro system, it has a really good macro debugger (it lets you view how the code is iteratively expanded with options to show/hide the expansion of various macros). Since even non-hygienic macros deal with syntax objects and not just datums, macros don't even screw up error messages since line/column info is preserved!

- You compile to executables unlike most scripting languages.

- You can write some code with types and some with them, but unlike say TypeScript the boundary between typed and untyped code is sound since contracts are used to verify these boundaries.

- A lot of the time you don't even need types because most names (i.e. variables and functions) are verified at compile time (to be more specific, at macro expansion time).

- It has very aggressive sandboxing tools that let you control not only what names are visible to some untrusted code, but also control how much memory it uses without creating a new process.

- Safer global variables in the form of parameterize. Very convenient for stuff like when you need to temporarily change the stdout for a single call.

[1]: https://github.com/datacamp/antlr-tsql/blob/master/antlr_tsq...

I use ActivityLog2 which also reads FIT files.

https://github.com/alex-hhh/ActivityLog2/releases

Don’t believe me? Check out the interactive gui stuff at https://alex-hhh.github.io

Check out this guy's page I just came across here. He's got a bunch of gui based Racket applications that look really cool.

I use and like Activity Log 2 - https://github.com/alex-hhh/ActivityLog2. You can import most common file formats like TCX, GPX and FIT.

This https://github.com/alex-hhh/ActivityLog2 works quite well for FIT files on desktop.

If you just want to track your workout data, there are far better softwares/websites to do it, I mean strict data analysis. As you don't give something to social part, could be great. GoldenCheetah , Github-ActivityLog2, TrainingPeaks:WKO5, Runalyze

As suggested I can record my activities from my watch/bikecomputer, and sync later, there are some apps who is kinda nice: GoldenCheetah, Runalyze, TrainingPeaks/WKO, Github: ActivityLog2, but I have not found a own-private-local cloud solution... OsmAnd+ and LocusMap are doing a good recording job as well, have not check if those recorded track/activity can be shared/transfered easily on a owncloud.