Skip to main content
146 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
Best practices
0 votes
1 replies
62 views

How to automate deployment of Superset dashboards, charts, and datasets to the target environment (UAT/Prod) from Bitbucket using a CI/CD pipeline running on Cloud Build, Bitbucket Pipelines, or ...
Manish Kumar Pandey's user avatar
  • 11
0 votes
1 answer
303 views

I'm currently using Liquibase version 4.29 in my Spring application and I want to run Liquibase updates programmatically instead of via the command line. I have enabled Liquibase with the property ...
Maddy's user avatar
  • 11
0 votes
1 answer
778 views

I have an existing postgresql database. I am trying to apply version control tool like flyway. I am using desktop app community version 6.6.1.0. I am trying to create a baseline script from here. But ...
Barun Bhattacharjee's user avatar
  • 452
0 votes
0 answers
201 views

I am working with sqlalchemy-continuum to use versioning on selected database tables in a flask app with mssql. In my end-to-end tests I run a flask app context that populates flask's global g object ...
user avatar
0 votes
1 answer
130 views

i'm supposed to version the records in a database by year. so if i get a new file from the year 2023 the entries should be changed according to the year. i'm not finding anything useful to versioning ...
user16350182's user avatar
  • 13
0 votes
2 answers
195 views

i have vespa verion 5.220.14 installed in one server where i have used json (provided by gson lib ) in searcher, while i am deploying the same code in vespa version 5.550 in a diffrentserver it is not ...
divyansh's user avatar
  • 23
2 votes
1 answer
106 views

I would like to allow for versioning of text in Vespa. If a user changes certain fields over time the changes would be tracked and versions could be restored. I imagine a solution running in parallel ...
SirGanya's user avatar
  • 141
1 vote
1 answer
902 views

I am new to rails. I want to track the versions of my record using paper_trail gem but I am not able to do so when I use the update_columns method. I think overriding the update_columns method may ...
Screw Ball's user avatar
  • 11
0 votes
1 answer
454 views

I'm working on a project where users could upload excel files into a MySQL database. Those files are the main source of our data as they come directly from the contractors working with the company. ...
Aybrl's user avatar
  • 1
3 votes
1 answer
700 views

With the versioning concept of having a extra history/revision table for each table, where you want to keep track of the changes, I am wondering how to handle the relationships (foreign keys)? Example:...
user3077796's user avatar
  • 192
-1 votes
3 answers
162 views

I'm working on an android app for some days using SQLite as databse. Sometimes I had to add column. For this reason, I just change database version and write down the changes in onUpgrade() like this: ...
Riyad's user avatar
  • 19
2 votes
0 answers
192 views

I am currently working on database versioning project. And I'm using a SQL Server Database Project for this. But we'll not use local database on the SSDT Project. Therefore I don't want to deployment ...
Gamze's user avatar
  • 21
1 vote
1 answer
1k views

I am developing a C# ASP.NET Core web application for Azure. I am using the Microsoft Azure Storage Emulator for local testing: https://learn.microsoft.com/en-us/azure/storage/common/storage-use-...
Claus Appel's user avatar
  • 1,783
-1 votes
1 answer
243 views

MariaDB has this cool feature of tables versioning that allow you to keep track of data changes within a table like a VCS. According to Django documentation, MariaDB is supported by the latest Django ...
Fabio Magarelli's user avatar
  • 1,101
2 votes
1 answer
315 views

what are the possible ways to version your RDF store in gitlab?
ammo's user avatar
  • 39
3 votes
1 answer
1k views

The problem Consider these database tables: Product Order Order Details User Product has columns: Product_Name, Product_Description, Product_Size, Product_Cost, Product_Unit Order has columns: ...
Karan Desai's user avatar
  • 3,202
0 votes
0 answers
230 views

I have a model that looks like this: class WidgetStack < ApplicationRecord belongs_to :widget belongs_to :person validates :quantity, numericality: { greater_than_or_equal_to: 0, ...
David Gay's user avatar
  • 1,164
0 votes
1 answer
1k views

I am trying to create containers with Liquibase implementation which can connect with the Google Cloud Spanner. I am getting the following error: Caused by: com.google.cloud.spanner....
Ishan Saxena's user avatar
  • 69
0 votes
1 answer
234 views

The project We are ~50 developers plus DevOps staff and run ~30 Oracle 12c EE instances. We have introduced Liquibase in 2018. We use the Liquibase Maven plugin version 3.8.8, changelogs are stored ...
Phut-U-Rama's user avatar
  • 1
2 votes
1 answer
1k views

I have a table in a database that stores products to buy (let's call the table Product). It's necessary to track changes of every product. I have 2 ideas for versioning records. First is to create a ...
Dune's user avatar
  • 704
2 votes
1 answer
2k views

I have database migrations that use database1. I'm using it for Alembic for migrations. How do I create a database database1 before running alembic? I've created a database infrastructure using ...
Ganesh Satpute's user avatar
  • 3,999
0 votes
0 answers
107 views

I would like to provide my users with a session or workspace using Azure SQL DB where they can take a snap shot of the database and cook up their changes, analyze the result and then submit the final ...
StackCraker_George's user avatar
  • 1
0 votes
1 answer
570 views

I'm trying to create a DB Table, using an NHibernate *hbm.xml mapping file, that will have a Versioning Column for concurrency check. The Versioning column should be a nullable Integer. Although the ...
Queenferno's user avatar
  • 1
0 votes
0 answers
286 views

I have 2 DB instances running on dev and prod. In dev I have created a table students with the following schema create table students (name varchar(20), age int, place varchar(100)); I created the ...
din_oops's user avatar
  • 718
0 votes
1 answer
2k views

I could not figured out why non of the change-set is getting executed and reflected in DB. I have referred this link as well,it has same issue unfortunately there is not answer on this post . In ...
Tam's user avatar
  • 4,027
0 votes
1 answer
897 views

I require a data store that will maintain not only a history of changes made to data (easy to do) but also store any number of proposed changes to data, including chained proposals (ie. proposal-on-...
Ben's user avatar
  • 21
3 votes
1 answer
1k views

I want to use the key-value pair feature of Cassandra. Until now, I have been using Kyotocabinet but it does not support multiple writes and hence, I want to use Cassandra for versioning my tabular ...
aviral sanjay's user avatar
  • 993
3 votes
0 answers
576 views

I have database with schema controlled by separate department. I would like to make some columns optional with default values. I think it would be best if I could set attribute [...
Shadow's user avatar
  • 2,577
0 votes
1 answer
50 views

I'd like to receive some advice from all of you. What is the best way for me to alert users on an update to my app? My app is a very knowledge-based & it works like a dictionary, so there will ...
F4y5's user avatar
  • 43
1 vote
0 answers
30 views

Let's say a supermarket has one table with statistical revenue data by business day. In a second table they want to try out different variations of these data, f.e. less bakery revenue at 1st January, ...
Stefan's user avatar
  • 11
0 votes
0 answers
912 views

I use Loggable to backup changes in Entities. The default AbstractLogEntry does not have enough columns for my needs. Thats why i extended the class and added extra getters and setters. See the code ...
Puya Sarmidani's user avatar
  • 1,299
3 votes
1 answer
2k views

I have a Rails project that has models versioned using the paper_trail gem. I'm looking to have that when I restore a version, I only want to change the fields that were changed in that particular ...
bwalshy's user avatar
  • 1,135
1 vote
2 answers
235 views

I have the following data structure in my current Firebase real-time DB: public class E { public int x; public int y; public int x; } This database is currently in use by my Android application ...
CaptainNemo's user avatar
  • 1,550
1 vote
0 answers
62 views

I'd like to store a number of product inventories. Each inventory is keyed on a product ID, and each product has arbitrary attributes. I want to take proposed changes to products (which may be several ...
Isvara's user avatar
  • 3,473
12 votes
1 answer
9k views

I want to add versioning to my documents in my MongoDB. Are there any best practices for versioning in MongoDB? And what's the simplestway to versioning documents in my MongoDB?
David Renz's user avatar
  • 375
1 vote
1 answer
820 views

I have a mongodb database with collection documents that are approximately as follows: // book document { _id: $oid, userId: "..." name: "name", description: "description" status: ...
Lorenzo Polidori's user avatar
  • 10.6k
1 vote
1 answer
1k views

I am just starting with flywaydb. Let's consider the case of having 3 databases - PROD, TEST, DEMO. On each upgrade (and without flywaydb), there are usually a set of sql files that need to be ...
mmalmeida's user avatar
  • 1,055
10 votes
2 answers
24k views

I am using liquibase 3.5.3 to run liquibase update command on MySql 5.5. I have below changeSet to create a table which has a column as Created_Time that should have a default value as ...
Suraj Prajapati's user avatar
  • 103
1 vote
1 answer
46 views

how can I use wordpress core for continuous integration/deployment. it seems wordpres completely work with database changes. it means when I change my local and users change production there is a ...
Hamid Shariati's user avatar
  • 599
-1 votes
1 answer
93 views

I want to use Fluent Migrator for database migrations for my .net project. Anyone has success stories of Fluent Migrator integrated with XL Deploy for database deployment? Regards, Pandian.
Pandiarajan's user avatar
  • 430
2 votes
0 answers
356 views

I'm trying to figure out IBM Informix database versioning, or release naming conventions. I'm trying to map out the differences between minor versions and fixpacks. According to IBM's own ...
Lotusmeristem's user avatar
  • 75
1 vote
1 answer
792 views

I am using flyway for database migration. I need to use it across different environment (qa, demo, prod) so have created a base folder (which runs all migrations) and environment specific folders. ...
enigma's user avatar
  • 41
0 votes
0 answers
32 views

Let's say I use Core Data with entity 'Book' which has 'name', 'author', 'summary' and 'isFavorite' attributes. I prefill the Core Data and the only attribute which user can edit is 'isFavorite'. In ...
Евгений М's user avatar
  • 25
18 votes
1 answer
14k views

I am working on a Django + DRF Web Application and I want to track changes to all model instances in the Database and keep a log of all changes made, namely: TABLE - Table to which record was added/...
Divij Sehgal's user avatar
  • 655
1 vote
1 answer
39 views

I wasnt sure where to post this or what I should use for this. I recently learned that Twitch updates every single day and gives 1 random user a golden kappa face. I want to know how it's done, and ...
martin j's user avatar
  • 131
5 votes
0 answers
7k views

My models are made of flask-sqlalchemy on top of postgresql. I want to keep track of changes made my models. I have a employees table: class Employee(db.Model): __tablename__ = 'employees' id ...
ISONecroMAn's user avatar
  • 1,536
2 votes
1 answer
4k views

I was going through this post for record level versioning of tables. I noticed that the architecture deals with the usage of history tables. However, my scenario does not require rollback but ...
dmachop's user avatar
  • 894
-1 votes
1 answer
160 views

I'm trying to build a process of refactoring, testing and deployment of my databases. After some kind of research I found liquibase as a nice tool for managing my database versions. As well similar ...
Mykola's user avatar
  • 618
2 votes
1 answer
625 views

I have a database (SQL Server 2008 R2), which is mostly under source control (so one file per DB object, grouped together in folders e.g. tables, views, storedprocedures). At the moment, changes are ...
David Keaveny's user avatar
  • 4,170
0 votes
2 answers
878 views

I have two DB tables in PostgresSQL database: create table actual (id int, name text, version int) create table history (id int, name text, version int, actual_id int) When a record changes it is ...
ike3's user avatar
  • 1,820

1
2 3