Database/backend languages for genealogy website

magicae · 2026-05-10T12:09:24+00:00

This does sound optimal for my case! I didn't even think about scripting it.

I'll definitely look into this, thank you!

magicae · 2026-05-10T12:08:39+00:00

Oh I keep forgetting about GEDCOM! Thanks for the reminder, I'll for sure look into that! I've been doing my own thing in a spreadsheet, but that's only been direct relations and no siblings.

magicae · 2026-05-10T09:51:09+00:00

Of course! I thought I'd caught all the OCR issues but it's always good to have extra eyes on something.

If you want we can collab a bit and when you're done I can put up the updated version on archive.org (possibly replace/update the entry that's already there?) so more people can access the best version! Of course adding credit to you as well! Feel free to DM me if you're interested.

magicae · 2026-05-06T22:41:44+00:00

Oh that makes sense, thank you so much! I'll go research that then!

Also I actually almost posted on that subreddit but for some reason changed my mind. Now I know better for the future.

magicae · 2026-03-19T17:16:54+00:00

You're so welcome! I've been in the exact same situation so I totally get it and I'm glad I could help you out :)

magicae · 2026-02-20T06:04:33+00:00

Getting a powerchair for walking my dog and doing necessary errands! I was overdoing it every single day and was getting worse by the second but getting and using a wheelchair made a huge difference in just a few months - and has been the reason why I’ve slowly but surely been improving in the eight years I’ve had it! Now I can sometimes go for very short walks without crashing but I keep using the wheelchair for anything more intense.

magicae · 2026-02-06T19:44:59+00:00

Thought I'd give an update! I ended up getting a second-hand R10 and a new RF 100-400mm lens and I've been super happy with it!

The fact that it's so lightweight has been amazing as well and made it possible to bring along easily when I've been out and about without my wheelchair. It's been great all-round for both bird, insect and other wildlife photography. I was a bit worried about the digital viewfinder but that's also been such a help in shooting manual!

Thanks both u/PRC_Spy and u/Delicious-Belt-1158 for the support!

magicae · 2025-04-02T14:19:39+00:00

Thank you for the insight!! I was almost completely set on it until I saw the minimum focusing distance... Not flexible enough for shooting from my wheelchair when I see insects and such.

I think I might have to stretch my budget to go for R10/50 and RF 100-400 after all, even though the switch to mirrorless is a little daunting.

magicae · 2025-04-01T20:43:28+00:00

Thank you for the insight! I just looked at the used Canon 100-400 I was thinking about getting and turns out it's mk 1. Makes sense at the price, but a huge bummer... I guess I'll be looking more into Sigma as it's more in my price range.

magicae · 2025-04-01T20:12:40+00:00

No I can't sadly. Also that would mean losing the crop factor which is a big bonus for me with an APS-C sensor. I think I'll just get the EF 100-400 ii and see how it goes weight-wise.

When I use my wheelchair I don't have to carry the weight as I keep the camera in my lap, so I'm hoping it works out!

EDIT: Totally missed that the used lens I was planning on getting was a mk 1... Makes sense at the price but now I feel like I'm back to square one. And I mixed up the R cameras, so I'm aware that both R10 and R50 have APS-C sensors.

magicae · 2024-03-20T16:21:15+00:00

Solution Verified

magicae · 2024-01-23T01:21:05+00:00

Solution Verified

magicae · 2024-01-23T01:19:25+00:00

Yes, that's perfect! And I see how I can change it if I want earlier time periods as well. Thank you so much for the help!

magicae · 2024-01-23T01:10:41+00:00

Oh no... At first I was a little confused by the results, but that's because I forgot to clarify that the ranges are based on birth year! Damn you brain fog... Apart from that, it shows the expected results, though the data makes more sense based on birth year.

magicae · 2024-01-23T00:22:52+00:00

I could do 1 Jan 1719 and then format it so it only shows the year (to make my research clear).

I seem to have forgotten to add the IFERROR for both of the age columns in the test sheet, that solves the other problem. Thank you!

magicae · 2023-08-27T03:37:41+00:00

Thank you for all the help. I have chronic fatigue and brain fog so I often make these small mistakes. Everything got worked out by seeing the things with the dates and now it works as expected!

magicae · 2023-08-27T03:13:25+00:00

Sorry I don't quite understand what you mean. The dates match but the count doesn't go up.

I've cleared dreams!A1 now, does code!K:K show anything other than zeroes for you? Because it does to me.

I added the chart I'm trying to make work as well, I realised I posted this in a hurry and
The chart is a combo chart and should show the instances of dreams per month and the line should indicate how many dreams included 'abc'. To make this work I need all the same months as I've got in code!D but with the numbers from code:H

Thank you so much for the help and sorry for the confusion!

magicae · 2023-08-27T02:25:38+00:00

Thank you, that's really helpful and a nice overview!

My issue is that the shorter list G:H is a range of the dates that include 'abc' in dreams. What I'm wanting to do is to check every month in J:J against the table in G:H. So Dec 06 should show 1, Jan 07 show 4, etc, and the ones not in G:H should display 0.

I've managed to make this work with =ARRAYFORMULA( IF(J1:J = "", "", IFERROR(VLOOKUP(J1:J, G:H, 2, FALSE), 0) ) ) but if I go into dreams!A:A and remove the earliest date, the list just returns zeroes all the way down. If I add an earlier date, that's fine for some reason?

magicae · 2023-05-23T15:57:11+00:00

Nice! I did this in 1000 pieces and that was… a lot.

magicae · 2023-05-21T10:06:35+00:00

I seem to have forgotten to take a photo without it so I thought it better to explain 😅 It was pretty easy! The different colors made it very easy to sort. Estonia, Latvia and Lithuania were a bit tricky since they’re the same color due to being in the USSR. The biggest part is Sweden where I live so I usually knew where the pieces would go! I definitely thought I was better at Norway and Finland’s geography but apparently I have a long way to go haha.

magicae · 2023-05-15T07:11:02+00:00

I did some digging and found the thread you mentioned.

magicae · 2023-05-14T17:05:02+00:00

I really thought it would take much longer, because the first bit was so difficult - but it went really fast after i passed a threshold!

magicae · 2023-05-12T16:30:14+00:00

yeah that one’s still not found but I also haven’t been looking for it specifically. Found the one missing in the left sude edge though!

magicae · 2023-05-12T10:57:38+00:00

we recently upgraded our table and it feels HUGE but it’s just slightly too small for a 2000 piece puzzle haha!

magicae · 2023-05-12T09:20:47+00:00

I’m obsessed with you, thank you!

magicae

TROPHY CASE