E52F Feature/add cassandra db by brendonatkins · Pull Request #1 · nextdc-dev/DbUp · GitHub
[go: up one dir, main page]

Skip to content

Feature/add cassandra db#1

Open
brendonatkins wants to merge 2 commits intomasterfrom
feature/AddCassandraDb
Open

Feature/add cassandra db#1
brendonatkins wants to merge 2 commits intomasterfrom
feature/AddCassandraDb

Conversation

@brendonatkins
Copy link
Collaborator

No description provided.

@brendonatkins brendonatkins marked this pull request as ready for review June 16, 2022 04:38
src/DbUp.sln Outdated
EndProject
Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "dbup-redshift", "dbup-redshift\dbup-redshift.csproj", "{7E77DD23-2E16-471A-897B-C67FB73C62C8}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SQLiteSampleApplication", "Samples\SQLiteSampleApplication\SQLiteSampleApplication.csproj", "{FD894CD2-4D67-4BD8-8E3C-CDA4BD7A00A3}"

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Will this change cause any upstream issues?

Copy link
Collaborator Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

ooh good catch

/// <summary>
/// Creates new Cassandra Connection Manager
/// </summary>
public CassandraConnectionManager(string connectionString) : base(l => new CqlConnection(connectionString))

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Could this be a discard instead of 'l'?

return
$@"create table {FqSchemaTableName} (
id UUID PRIMARY KEY,
script_name text,
Copy link

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Does this need to be a partition key?

Copy link
Collaborator Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

My thinking was id being the sole partition key. Due to value being generated the partitions should rotate around. Given each script name will be unique again partitions would rotate around. What is the benefit of the composite partition key?

Let's chat.

@brendonatkins brendonatkins force-pushed the feature/AddCassandraDb branch 3 times, most recently from b695921 to d251d35 Compare July 4, 2022 22:25
Pull in DataStax C# driver to interact with Cassandra 3.

Add support for script execution and journal.
Using "schema" variable to represent a keyspace. Does not create
 keyspace - if keyspace is provided then assumes it is present. DBUp can
 be used to execute a script to setup keyspace if running with a
 NullJournal.
@brendonatkins brendonatkins force-pushed the feature/AddCassandraDb branch from d251d35 to f3a0f06 Compare July 4, 2022 22:31
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants

0