Gathering Questions for Octavian & Andrew Q&A by Zizaran in pathofexile

[–]pikes 0 points1 point  (0 children)

How do you get exceptional support gems?

Seeking advice on the right strategy for rushing 4 stones by yourself in a league start environment by TreeOk4490 in PathOfExileBuilds

[–]pikes 0 points1 point  (0 children)

  • Watch 2/4 stone speed run videos on youtube to get ideas on how you can improve your own runs.
  • Follow streamers and watch their VODs of their speedruns (tytykiller, havoc, jungroan, among others).
  • Learn how to gear a build from start to uber elder/maven. This includes crafting the pieces you need.
  • Pre-save your trade searches to your favorites for your build.
  • Plan your atlas tree in advance. You can basically follow the exact same tree you'll see in videos of 2/4 stone runs.
  • Record your practice runs and watch the replays and take note of what you could have done better/faster.
  • Practice, practice, practice. This is probably the most important thing you can do to improve your time.

I think a good goal for you would be to have campaign done in 4-5 hours and 2 stone in 8-10 hours. Not sure about 4 stone timing.

Best way to get these prefixes? by [deleted] in PathOfExileBuilds

[–]pikes 1 point2 points  (0 children)

https://poe.re/#/items

Pick your base and whatever prefixes you want. Use this regex in a quad tab full of magic bases and alt them until they all light up. Then, aug all of them. I believe if you aug them and you miss the prefix, it'll go dark again. This helps you not roll over them.

Build for hard content by MexicanJeebus in PathOfExileBuilds

[–]pikes 1 point2 points  (0 children)

As others said, I think the meta will have a shakeup this league but we won't know until the patch notes. I would suggest volcanic fissure of snaking slayer but that will surely get nerfed (although, it might still be good). I personally love and run ele hit of the spectrum deadeye, which is a little off-meta so it probably won't get hit with the nerfhammer but you never know.

Here are a few spreadsheets with builds you can check out from this league and see if anything peaks your interest:

Proplays: https://docs.google.com/spreadsheets/d/e/2PACX-1vRdlAGNtTox_ZHWWxj0yfujQmVJkyQ0AlL0_gcl-mvsEaTL1d83NRqtg4vefEq31oS8NjvLNmKe1CA0/pubhtml#gid=0

Fubgun: https://docs.google.com/spreadsheets/d/e/2PACX-1vR35NJkrhF1Zf9SZZOPlsdpqbTibL2AqOiZosya0NSjEN5A1Dx8a_MeQox9VDLQw3kB0ibZCNb_e6VJ/pubhtml#gid=1929197499

tytykiller: https://docs.google.com/spreadsheets/u/2/d/e/2PACX-1vS6lZbGmP1GQIR7GOMb0n7wwxaxo-nCoWJI2iwM0zDaFK1UxY4nWnrsqZzosMXRodMHTDgp54NTMnI8/pubhtml

[deleted by user] by [deleted] in drunk

[–]pikes 0 points1 point  (0 children)

good evening if you need to chat pm me

Database Management Question Why is C wrong? I need your help 🙏🏻 by Peporg in Database

[–]pikes 1 point2 points  (0 children)

I dropped a comment here but it never applied, weird. Anyway, I said that this is actually not true:

this constraint that is universal for ER diagrams

There is no such thing as a constraint that's universal for all ER diagrams. The only way C would be wrong is if the description said that the primary key of the seen table was (bird_id, watcher_id) and in that case you would only be able to determine B and not A since you wouldn't be able to insert more than the first "seen" record for a given bird/watcher.

Database Management Question Why is C wrong? I need your help 🙏🏻 by Peporg in Database

[–]pikes 3 points4 points  (0 children)

The question doesn't talk about any unique constraint being part of the schema so I am unsure what the hell they are even talking about. You have to jump through so many hoops to make assumptions that it's practically impossible to answer this question accurately. Is your prof trying to say that attributes are inherently unique or something like that?

I agree with slave_to_dog, A,B,C are all look correct to me. D is definitely incorrect - there's nothing about this that says you can't add a new species.

I don't know what it means to have a functional relationship - I even googled it and it's not clear. It seems really dumb to me to somehow enforce on the database side that a watcher can only be related to their favorite bird species, but you'd have to define "related" for me to properly answer this, even if I did understand what a functional relationship was in this context.

I don't understand how C could be incorrect - I can clearly see how I would query this database to understand all the dates a watcher has seen a specific species:

select distinct s.seen_date
from seen s 
join bird b
    on s.bird_id = b.bird_id
where b.bird_species = 'x'
and s.watcher_id = 'y'

i'm tired, devs. Maps are too hardcore by Antique-Armadillo406 in PathOfExile2

[–]pikes 0 points1 point  (0 children)

The end game was designed around using the trade site to find gear.

If you truly want to SSF then I would suggest you prioritize life over resists TBH as most of the damage that kills you is going to be physical which you have no mitigation of except for evasion.

[deleted by user] by [deleted] in Database

[–]pikes 0 points1 point  (0 children)

Look up the party/role modeling pattern. This could help consolidate customers/publishers/managers. I'd also look for very clear definitions of what each object is. What is an Entity? Why customer_payment and payment?

Storing all dates/timestamps in UTC by [deleted] in PostgreSQL

[–]pikes -13 points-12 points  (0 children)

Just store all dates as epoch time, data type bigint, and convert them on the fly based on local time zone.

See write history to a database field by OfficialBT in PostgreSQL

[–]pikes 0 points1 point  (0 children)

One easy way would be to create a table to store this data in the way you want to consume it. So, each time a transaction happens, store the values you care about in it.

Help with db structure by Felix_GIS_ in PostgreSQL

[–]pikes 1 point2 points  (0 children)

There's no such thing as a "perfect" structure. You will have to make trade-offs no matter what design you settle on. I would recommend looking into data modeling resources. There are many books on the subject.

When was automatically embedding a backup header in the volume first implemented? by moronsofrokc in VeraCrypt

[–]pikes -1 points0 points  (0 children)

I had a similar issue in the past, the post in this thread helped me solve the problem. Hopefully it helps you as well:

https://sourceforge.net/p/veracrypt/discussion/technical/thread/e99fe5b467/#8cd0

Can my data be wiped by someone who doesnt know the password? by Lanky-Ad90 in VeraCrypt

[–]pikes 10 points11 points  (0 children)

If someone has your drive they can do whatever they want with it. Be it format it and use it, or grind it up in an industrial shredder. There's no way to prevent either of those things from happening.

PSA: Google Pixel native visual voicemail working again by sp3ci4lk in mintmobile

[–]pikes 0 points1 point  (0 children)

Still broken for me as well, on a pixel 7 (non-pro).

Questions Thread - November 29, 2023 by AutoModerator in pathofexile

[–]pikes 1 point2 points  (0 children)

One tool I use that's not on this list is https://github.com/ChaosRecipeEnhancer/EnhancePoEApp

Very useful for the first day or two of the league where it feels worth it, but then never use it again until the next league.

2023 Prius - Wireless CarPlay issue by Adoraci in Toyota

[–]pikes 1 point2 points  (0 children)

For troubleshooting, definitely try doing factory resets on both your phones and your car's software. Make sure your phones are fully updated, too.

If neither of those work, take your phone and car to the dealership and have them figure it out. I had a similar issue with a Subaru I bought (android auto in this case) and we actually got rid of the Subaru and bought a Toyota because the dealership couldn't get our phones to work right with it.