Game Discussions Star Citizen Discussion Thread v12

sovapid

sovapid
Agony_Aunt said:
Hold on, i'm not talking about a database that is going to be accessed that frequently or need for constant updates. Just something that is there to track the ships people have.

So, the game (via whatever DB), knows what player A has. Player A buys a ship with in-game credits. Now, this info goes into the fancy schmancy entity graph DB, but its also written to your bog standard SQL DB as well, a simple list of ships owned. Player sells a ship or its permanently lost, then again, that info is also removed from the other DB as its removed from the main one.

Main DB has to be wiped (again, i still don't believe this should have to happen if CIG were competent about what they were doing), they can grab the info from the standard SQL DB and import that data back into the one that was wiped.

No need for cross DB queries as part of the live game.

If they simply can't script that, then i would have to suggest that whatever they are doing is bad design or a lack of talent.
Click to expand...

The wipes make sense if the game code is writing a bunch of inconsistent junk to the database and trying to straighten out all the junk is more time than it is worth.

That would be the same issue with the separate DB for in game purchased ships. Sounds plausible, but you still have the game code going crazy and writing a bunch of nonsense to it.

The purchased stuff is bog standard db stuff and that data only goes in one direction. To the game db when there is a wipe.

And all this is a bunch of guessing because we dont know what they are actually doing.
 

Ed02349

E
Agony_Aunt said:
LOL, its not version 2, its version 12.

However, it used to be there was a limit to the number of posts, can't remember how many, maybe 5 or 10 thousand. But with the new forum software its more or less unlimited, so we won't likely ever see version 13... well, unless CIG keep this show going for another 50 years....
Click to expand...
And I thought it stops at version 12 because Star Citizen isn't really going anywhere and there's nothing new worthy of a new thread.
VR Golgot said:
Oh yeah I did a bunch ;)

It's kinda nice to pick out mini-stories from the decade-reviews. Like this strand didn't really jump out at people at the time:

Source: https://youtube.com/shorts/_U8fD5MuXbY?feature=share


But when you contract the timeframe the issue becomes more obvious ;)
Click to expand...
It's almost as if they add things on a whip withoout planning out how it all interacts together from the begininng.
 

Navigare Necesse Est

Navigare Necesse Est
Ed02349 said:
And I thought it stops at version 12 because Star Citizen isn't really going anywhere and there's nothing new worthy of a new thread.

It's almost as if they add things on a whip withoout planning out how it all interacts together from the begininng.
Click to expand...
The bell never tolls the 13th hour. That happens only for the Skaven in Warhammer.
For the Vermintide and the Skittergate! skitter, skitter, smacklips
 

VR Golgot

VR Golgot

Christopher Roberto

C
VR Golgot said:
robertsspaceindustries.com

Star Citizen Alpha 3.18.1 - Live Release & Free Fly - Star Citizen Spectrum

Hello everyone, The much-awaited release of Alpha 3.18.1 is set to launch later today. While we know that this incremental update is not a silver bullet, we expect that it will bring solutions to...
robertsspaceindustries.com robertsspaceindustries.com
Click to expand...
Why do they always do free fly events when it's in the worst possible state? They're so consistent about this that it must be a strategy. Maybe people do a "the graphics tell me that the gameplay has so much potential!" and buy in low, then see it consistently improve since there's nowhere to go but up and that gives the longest possible runway for upselling?
 

VR Golgot

VR Golgot
Christopher Roberto said:
Why do they always do free fly events when it's in the worst possible state? They're so consistent about this that it must be a strategy. Maybe people do a "the graphics tell me that the gameplay has so much potential!" and buy in low, then see it consistently improve since there's nowhere to go but up and that gives the longest possible runway for upselling?
Click to expand...

It is perplexing isn't it.

I sometimes wonder if they've stumbled on it as a way to sort the wheat from the chaff. IE keep the ones who will happily buy into a dream, (plus the gamers who are just happy with a box of sand and chaos, or some slow-moving scenery), and repel the ones who are looking for a fully fledged game.

The last lot would kick up more trouble in a shorter time frame ;). And also probably spend less...

I imagine the free flies that run alongside the ship shows do especially well...
 

Darkfyre99

Darkfyre99
VR Golgot said:
It is perplexing isn't it.

I sometimes wonder if they've stumbled on it as a way to sort the wheat from the chaff. IE keep the ones who will happily buy into a dream, (plus the gamers who are just happy with a box of sand and chaos, or some slow-moving scenery), and repel the ones who are looking for a fully fledged game.

The last lot would kick up more trouble in a shorter time frame ;). And also probably spend less...

I imagine the free flies that run alongside the ship shows do especially well...
Click to expand...
#Not_A_Cult
 

cigwatch

cigwatch
OMG, I think I don't want to go this deep, but:
  1. In the simplest scenario there is a real world transaction table outside of the graph. If graph gets PESed up, we can still populate it with basic ownership information based on that table, like @sovapid said. Since we wipe the graph beforehand there is really not much to manage. And wipes are necessary because CI didn't take enough care (not enough knowledge?) about maintaining their graphs in a consistent, sane state as opposed to surreal horrors of the current 'verse.
  2. We try to shoehorn in-game transactions into the same table. Still, after a wipe, we should be able to recover ships bought in game. But now we have a table that serves two completely different purposes - tracking business transactions and maintaining part of the state of the 'verse, which is problematic on several levels, from database design (a lot of overloading and nullable columns) to system design (mixed domains in a single table, uncertain where to put other transactions like buying resources). These issues could be partially addressed by having another table outside of the graph that tracks player inventory. Still, only works with occasional wipes (the table is the source of truth about some of the 'verse).
So yeah, this really does not require bi-directional synchronisation due to wipes.

Regardless, just think about it. They cannot maintain their graphs now. What will happen when they introduce culling? I mean, this is going to make things even more complex, because now they will need additional logic to cull right objects at the right time. More queries, additional delete transactions etc.

Let's say that my stance on whether they will be able to pull it off is PESsimistic. I expected they will cull exactly what should not be culled. Instead of empty soda cans, ships will start dissapearing.
 

ECity

ECity
3.18.1 is released. This should be fun:

1681341648957.png
 
You must log in or register to reply here.
Back
Top Bottom