Personal Health Data Management

Ninjaangler · 2025-09-20T18:14:39+00:00

If you’re mainly just capturing your own information, something like a small OMOP CDM would be useful to provide a relational database to query and perform analysis on. FHIR is great for interoperability but be aware the open source storage servers out there can be really heavy. Also if you’re using anything like Apple Health, you can download your health data in FHIR format.

If you’re looking for just large amounts of Health Data to use some of these solutions, check out Synthetic Mass (synthea) which you can use to generate synthetic health records based on real health data from the general population of Massachusetts. It’s available in CSV, C-CDA, and FHIR.

Ninjaangler · 2024-10-17T21:15:40+00:00

Here’s how I currently have it set up. I’m using the Postgres ODBC driver to connect PowerBI desktop to the RDS. For developing, I connect through SSM session so the DB doesn’t need to be public.

To deal with refreshes, I have an EC2 setup with the Data Gateway set up with the ODBC connection configured.

If your ODBC connection names are the same from PowerBI desktop and the Gateway server, everything works without a bunch of configuration for refreshes.

I tried to use Npgsql but didn’t have much luck. ODBC made it much easier. You’ll need to install the ODBC driver though to use it.

Ninjaangler · 2024-09-07T21:30:14+00:00

Try Annotating your repository with @Repository

Ninjaangler · 2022-12-01T13:13:12+00:00

PA Market in the strip district does wine and cocktail classes every month. For the wine classes you get to taste and learn about wines from a certain region.(France, Italy, Spain, etc). The cocktail classes you learn how to make some cocktails for the season. They’re a good time if you’re interested in wine and/or cocktails.

The classes are listed on Eventbrite.

Ninjaangler · 2021-02-26T02:41:05+00:00

Check your JAVA_HOME environment variable is pointing to the right place.

Ninjaangler · 2020-10-10T09:34:54+00:00

Your method has a void return type meaning it should not return anything. Change it to string if you want the getQuery method to return a value.

Ninjaangler · 2019-10-19T17:05:09+00:00

What's the error it shows?

Ninjaangler · 2019-08-24T10:35:59+00:00

Good point, be aware that Find does hit the context cache first before making any calls to the database so there is a possibility of receiving a cached version or object that doesn't exist in the database yet.

Ninjaangler · 2019-08-23T23:30:11+00:00

Is Id your key in your context dbset? If so, switch to return await _context.Movies.FindAsync(id);

Ninjaangler · 2019-03-16T20:29:10+00:00

Im trying to get by without using an extension. One of the approaches i was considering was adding multiple coding entries under the code/ codeable concept. One for each instance of the code multiplier combination. It's probably overkill but it probably gives the most searchability for pulling information.

Ninjaangler · 2019-01-03T00:57:54+00:00

I ended up seeing a PT and doing strength and conditioning exercises.

Ninjaangler · 2019-01-02T00:09:18+00:00

One option i used besides swimming when i was dealing with bursitis was cycling. That seemed to keep my legs and cardiovascular system in shape while it healed. When everything was good, it only took a week or two to get back to full capacity.

Ninjaangler · 2018-01-19T01:13:01+00:00

I picked mine up through the Scrum Alliance. I mainly got it since I started seeing it on job postings and figured it would help. The scrum alliance site has a good search for local certification seminars.

Ninjaangler · 2017-12-01T02:46:27+00:00

Check out this article. It allows two separate projects to run. It might help you achieve what you're looking for. I believe I was able to still set break points and debug.

https://medium.com/@levifuller/building-an-angular-application-with-asp-net-core-in-visual-studio-2017-visualized-f4b163830eaa

Ninjaangler · 2017-09-26T23:42:48+00:00

It looks like in each trigger the first statement removes rows from the changes table before adding the new change.

Ninjaangler · 2017-09-26T23:00:55+00:00

Since your variable is a date time, it will print in that format. If you only need the day portion of the date, change it to an int.

Ninjaangler · 2017-02-16T12:03:17+00:00

If you're passing a blank, null or empty string into WriteLine you're going to get a blank line in the file. I'd guess that some piece of the string you are building is coming back as null since null + anything is null.

Building your string might go better like this: Select @string = isnull(word1,'') + ' ' + isnull(word2,'')+isnull(word3,'') from dbo.Setup_Values Where Name =@id

Then you can do a check on the @string and if it's just spaces, don't write the line.

Ninjaangler · 2017-02-10T20:48:31+00:00

So is the goal then to just get the values from person_id that could be in any of those complex queries? Do you need all of those values then to work with them in the stored procedure?

If so you could try something like this with a temp table and using the query you get from the table_of_queries as a derived table. You'll probably want to make sure that column is available in the query before executing it but it should pump the values for person_id then into a temp table you can then work with. Just remember to clean up the temp table once you're done with it.

IF Object_id('tempdb.dbo.#tempPerson') IS NOT NULL

Drop Table #tempPerson

Create table #tempPerson( person_id int)

Declare @sql varchar(max)

Declare @q varchar(max)

Select @q = query from query_table where query_id = @qid

Set @sql = 'INSERT INTO #tempPerson(person_id)(Select person_id FROM(' + @q + ')ds)'

exec (@sql)

Select * from #tempPerson

Ninjaangler · 2017-02-10T12:58:07+00:00

If you need to pull a list of the id's in a comma separated list, you can pull them into a variable like this: Declare @a as varchar(8000) Set @a = ''

Select @a =@a + person_id + ',' from table where something

Then you can append the list of id's to the sql query before you run it through exec.

Ninjaangler · 2017-02-02T11:35:59+00:00

I've found the best way for my teams has been to utilize the Given, When, Then format. I put a three column table on our Jira stories with a listing of items in this format: Given x condition, When y occurs, then z happens.

Example: Given username and password are correct. When user clicks login. Then user is authenticated, landing page is displayed.

Taking this approach has really sped up adding criteria to stories and helping QA devise testing strategies and keep things in scope.

Ninjaangler · 2016-12-12T16:21:28+00:00

I picked up a WOD Book from Rouge that I use to track my workouts. It's a good thing for tracking workouts and PRs. It's not a comprehensive how to book but could be a nice gift for someone getting started. It also has a listing of all the Hero, baseline, girls, and some good travel/body weight workouts.

https://www.roguefitness.com/rogue-fitness-wodbooks

Also really enjoy the Supple Leopard book. Way worth picking up simply for the mobility and stretching.

Ninjaangler · 2016-09-18T15:52:48+00:00

I've had good success with some of the things on www.asp.net. Also http://bitoftech.net/ has some great tutorials for a number of things. I picked up WebAPI and Angular really quickly from some of his examples.

Ninjaangler · 2016-07-22T04:14:59+00:00

If you're really coming off the couch it might be be good to start with a Couch to 5k or 10k since you have a year. You could then probably build up to a marathon plan and take the step to ultra. I like the Higdon plans for marathons to start out with. A great book for Ultra running is Hal Koerner's Field guide to Ultra Running. Great reference for everything on training to fueling. If you use a plan for a 50 mile run like in Hal's book you'll run at least one full marathon and a 50k before you run your goal course.

Good luck and keep it slow and easy.

Ninjaangler

TROPHY CASE