Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [git]

10 questions
5
votes
1 answer

Visual Studio, GIT, and SQL Scripts

I am trying to figure out a way to have all of our random SQL scripts that we write under source control. I am already using SSDT for the database project. This is not for these sort of scripts. It is for all the other random queries that we run…
Anthony Genovese
  • 2,067
  • 3
  • 22
  • 34
3
votes
0 answers

Git as distributed and decentralized storrage with regard to ACID and CAP

When using Git to store documents distributed and decentralized it can be considered as a database. How would the ACID properties and the CAP theorem correspond to git in this case? I think one has to distinguish between a single repository and the…
white_gecko
  • 139
  • 3
2
votes
2 answers

pg_dump hangs in Git Bash but works in Windows command line

I tried to make a backup of a database from Git Bash environment, but the executable does not output anything. If I specify the filename using the -f flag, a blank file gets created, so the executable obviously runs, but it does not do anything -…
JohnEye
  • 173
  • 9
2
votes
2 answers

push using git integration in DBeaver

I am using the git plugin for DBeaver. While I can commit, I am not seeing an option to push the commit over to master. Am I missing something?
Saqib Ali
  • 121
  • 3
1
vote
2 answers

Attempt to build Cassandra Lucene index failed, cannot checkout version 4.0.7

Lucene Index is managed by Instaclustr (https://github.com/instaclustr/cassandra-lucene-index) in Cassandra 4.x instead of Stratio who supported till V3.x. I have tried to test the Index creation but failed with below issues. Anyone please help. I…
Cassandra Thrift
  • 307
  • 1
  • 7
1
vote
1 answer

Git corrupts SQLite database

I use SQLite for websites I create and manage for my clients (I am a web developer). They are very small and straightforward databases. This is now happened twice, so it is pretty clear that it wasn't a fluke. This last one was a clear set of…
Katie
  • 121
  • 5
1
vote
0 answers

Integrating Flyway and Github

I was wondering if any of you can share some experience regarding integrating Flyway and Git. We're currently developing a project, each sprint we need to make database changes for new features of course. Once every two weeks we merge changes made…
browsingThrough91
  • 11
  • 1
1
vote
1 answer

Sync'ing MySQL stored procedures to Git

Is there a decent way to sync MySQL database source code (ie: functions and stored procedures) to git? I'd like to be able to develop stored procedures within my IDE and version control them in git so I can easily move them between servers, and…
blindsnowmobile
  • 113
  • 1
  • 2
  • 10
0
votes
1 answer

Gitlab's praefect enormous wal generation on postgresql

We have praefect's database about 500 Mb in size, but wal generation per week is relly huge - about 1Tb. Most frequent query is being executed ~8 times/minute: WITH lock AS ( SELECT id FROM replication_queue_lock WHERE …
Daniil Aksenov
  • 1
0
votes
1 answer

Reading from .sql file located in Visual Studio repository

A user.sql file which contains USE [database] GO -- Legacy users cleanup DROP USER IF EXISTS [dw]; etc... is located at the repository: https://company.visualstudio.com/Database/_git/Azure?path=etc... I have a powershell script running on a VM that…
TheNixon
  • 371
  • 4
  • 12