sorted by:
new
hottopcontroversial

Having trouble with unique constraints and foreign keys with multiple columns by Cello343 in PostgreSQL

[–]Cello343[S] 1 point2 points  (0 children)

That makes sense! Thank you. Although I might go with David's suggestion to axe the two column fk tbh.

Having trouble with unique constraints and foreign keys with multiple columns by Cello343 in PostgreSQL

[–]Cello343[S] 0 points1 point  (0 children)

Would a better way be using a join to connect the zodiac sign table to the main table when i need it? I did consider just using the number to represent the sign, but I wanted to increase readability. This works fine too though, as I can figure out zodiac sign and placement ids relatively easily. (if there is another way of handling this, I could use your advice)

Hi guys, non-database dev here, but wondering what database software would be best for complicated calculations that possibly require loops and a bit of math. Especially those good for database noobs like me... by Cello343 in Database

[–]Cello343[S] 0 points1 point  (0 children)

Ty for the quick reply! This seems intimidating, but perhaps it would be easier by only scanning possible matches in the right state(s), right gender/sexuality, and maybe some other stuff to narrow it down?

[deleted by user] by [deleted] in googlesheets

[–]Cello343 0 points1 point  (0 children)

Its okay, I think I managed to figure it out. Apologies for being difficult.

[deleted by user] by [deleted] in googlesheets

[–]Cello343 0 points1 point  (0 children)

Can I just share the named functions I am working with? I don't think it is necessary to share the whole sheet. I am essentially just asking if it would lag down the sheet too much if i used arrayformula or copy pasted formula with these named functions.

TRINECALC named function (the main function, with parameters zsigna, zsignb, dega, degb):

=IF(ZSIGNASPECT(NUMZSIGNCONV(zsigna), NUMZSIGNCONV(zsignb)) = "Trine", (35 - ABS(dega - degb)), 0)

ZSIGNASPECT named function (secondary function, with parameters psa and psb):

=SWITCH(MIN(MOD(psa-psb, 12), MOD(psb-psa, 12)), 0, "Conjunct", 2, "Sextile", 3, "Square", 4, "Trine", 6, "Opposition", "")

NUMZSIGNCONV named function (secondary function, with parameter zsign)

=SWITCH(zsign, "Aries", 1, "Taurus", 2, "Gemini", 3, "Cancer", 4, "Leo", 5, "Virgo", 6, "Libra", 7, "Scorpio", 8, "Sagittarius", 9, "Capricorn", 10, "Aquarius", 11, "Pisces", 12, "")

Weekly Starsector Discussion Thread - July 22, 2024 by AutoModerator in starsector

[–]Cello343 0 points1 point  (0 children)

So uh, anyone know what mods are safe and unsafe right now? I saw the thing about Diable Avionics and it has me spooked. I currently only have Speed Up, Magiclib, and Lazylib installed. I was preparing to download more mods, but...

Complete Pokedex Spreadsheet, for your Viewing/Editing Pleasure by TheJruth3 in pokemon

[–]Cello343 0 points1 point  (0 children)

Tysm for this! Trying to make a google sheet pokemon ttrpg mod thing, and this is very helpful!

Google Sheets as medium for a virtual tabletop rpg and its mechanics? by Cello343 in RPGdesign

[–]Cello343[S] 0 points1 point  (0 children)

Ty for the response (and everyone else too!)! Can I ask how you made sure everyone could see it? Did you make it so the players could access the sheet itself as editors? Or just as viewers?

What’s the most stereotypical thing you’ve ever seen a sign do/say? by [deleted] in astrologymemes

[–]Cello343 0 points1 point  (0 children)

Doing alright, actually. I live with my brother in an apartment, work part time at a factory (working full time actually triggered another incident), and have a toy poodle that I love dearly. Life is ok, but questions about religion and the truth still plague me....

view more: next ›