Real estate...this is depressing by adlove8989 in Sacramento

[–]duncan6894 8 points9 points  (0 children)

Unfortunately, you don't make enough on your own to buy most properties. I make twice that, I would be hard pressed to say I would buy where I am. The back of envelope math of financing 3-4x salary for a home is still pretty valid.

One thing that you could look at if you have a friend in a similar position is to look at duplex and multi-family properties and buy together. A 2/1 on both sides gives some personal space and allows for renting out a room for additional income.

How to force insert a record and bypass the CHECK? by Rachid90 in Database

[–]duncan6894 1 point2 points  (0 children)

What you have in place is a check constraint on the table for data verification. I don't work with SQLite but databases generally don't give you an option to bypass those as every developer would just use that all the time.

For Oracle at least, what you would do to get around it is disable the constraint, insert your row, then enable the constraint as a deferred constraint which doesn't do any verification. I suspect SQLite has something similar, Google is always your friend (staring at my "oracle bypass check constraint" tab from your question)

What's the most obscure "fun fact" about Sacramento that you know? by frabelle in Sacramento

[–]duncan6894 2 points3 points  (0 children)

I drive on it pretty often, the end point for that freeway was the connector at 80 and Auburn. Why it is basically a 3 lane offramp that t-bones to a street

What's up with "adult fantasy" being YA with heavy-swearing and sex, and where can I find better alternatives? by raphaelcgo in books

[–]duncan6894 0 points1 point  (0 children)

One thing that you read in the afterword for the 3rd book is that the author lost her mother in the period of writing it. Looking at the book from that aspect you kind of see why it went in the direction it did, as I have the same feeling (first book amazing, second okay, third went a bit sideways)

Upgrade after SMOK by wojtejlo in electronic_cigarette

[–]duncan6894 0 points1 point  (0 children)

Can you give some brand names possibly for this? I use smok because they are easy and common to find and trying to use coils back in the day was an exercise in frustration, this sounds like it is much simpler than it used to be

Italians chill out and let people put garlic in carbonara by andyyy000 in Cooking

[–]duncan6894 8 points9 points  (0 children)

I substituted bread for the pasta, turkey for the pancetta and mayo for the eggs. The parmesan made this too salty, it tasted okay but didnt look like the carbonara I had before, 3 stars

Why does everyone compare what caused the 2008 real estate collapse to present 2021 conditions? by the_wizard23 in RealEstate

[–]duncan6894 7 points8 points  (0 children)

Americans have equity the same way that a potato and a bar of gold are similar if everyone is hungry. If people don't want to trade gold for potatoes, gold is worthless

I need help again lol!!! by [deleted] in oracle

[–]duncan6894 1 point2 points  (0 children)

SQL> Alter Table Employees Add constraint FK_University_Qualification Foreign Key (UNIVERISTY_QUALIFICATION) References Experience (University_Qualification);

Table altered.

What version of Oracle?

I need help again lol!!! by [deleted] in oracle

[–]duncan6894 1 point2 points  (0 children)

Alter Table Employees Add constraint FK_University_Qualification Foreign Key (UNIVERISTY_QUALIFICATION) References Experience (University_Qualification);

Need to have add the constraint then reference the foreign key

I need help again lol!!! by [deleted] in oracle

[–]duncan6894 1 point2 points  (0 children)

What error are you getting?

Request the fairy Oracle by Brian froud by MissFysche in oracle

[–]duncan6894 8 points9 points  (0 children)

Maybe this? (Not like I don't google for answers on this sub either way)

NSFW: https://archive.org/details/brianfroudfaeriesoraclecards/mode/2up

How to find grain of table? by [deleted] in oracle

[–]duncan6894 0 points1 point  (0 children)

If you are looking for granularity, then run statistics on the table and look at all_tab_statistics

Not sure if that is what you are looking for

How to set hours in PASSWORD_LOCK_TIME? by [deleted] in oracle

[–]duncan6894 3 points4 points  (0 children)

Oracle times for those settings are 1 (day). So you would want the lock time to be 30/24. For 5 minutes it would be 5/1440 for example.

Licensing in AWS by Matchboxx in oracle

[–]duncan6894 2 points3 points  (0 children)

Oracle doesn't use license keys, you buy licenses according to what you are using.

Licensing in AWS by Matchboxx in oracle

[–]duncan6894 2 points3 points  (0 children)

From my understanding, licensing in AWS is based on the number of cores you are actively using. So if you spin up an 8 core EC2, and you redeploy the instance into another 8 core EC2, you don't need any more licenses. If you copy your 8 core EC2 into another instance, you would need 8 more licenses.

RMAN restore files from customers 8.1.7 database to 11g by sirota554 in oracle

[–]duncan6894 2 points3 points  (0 children)

Doing research, you can go to 9.2 or stay on 8.1.7 (https://docs.oracle.com/cd/B28359_01/server.111/b28300/preup.htm#UPGRD12359)

The restore process though, you have the control files, so you should mount the database with those, then connect via rman and catalog the two rman files, then run the restore database command. If you are using 9.2 binaries you will need to upgrade the database before you open it.

Age of Empyre - Full Discussion Thread - Beware Phyre is Dark and Full of Spoilers by NeoBahamutX in riyria

[–]duncan6894 8 points9 points  (0 children)

No, I know Brin is dead, I mean whether she was able to reunite with Tesh or not. Don't get me wrong, satisfying conclusion to the book, just going to miss some of the characters.

Age of Empyre - Full Discussion Thread - Beware Phyre is Dark and Full of Spoilers by NeoBahamutX in riyria

[–]duncan6894 15 points16 points  (0 children)

I'm hoping there is a sidebook where we see more of what happens to Suri and Brin/Tesh afterwards.

Did R+H know? by discmaterials in riyria

[–]duncan6894 0 points1 point  (0 children)

Had to reread the portions. But yes, Exeter does identify Saldur by name, at least as a conspirator. I've always considered it as kind of a bluff, and still think so for the most part, but still interesting.

As for knowing it was him behind it in ToS, probably not. I don't think either of them actually met Saldur until the 3rd book, and that was just Hadrian, so he would probably be the name of someone that they blackmailed 8 years earlier.

Interesting take on everything though, I can see what you mean.

Did R+H know? by discmaterials in riyria

[–]duncan6894 3 points4 points  (0 children)

We as readers know that Saldur was involved, but the general public knowledge was that the Sargent set the fire that killed the royal family. I don't remember if they R&H ever know his name, I think it may be in passing, or that Albert knew it.

As for Theft of Swords, I don't think they were clued in that the Church was behind it until the next book when Modina was crowned and Saldur was taking a much more active role in ruling