Stack Overflow
Stack Overflow

Questions tagged [legacy-database]

Legacy database refers to use of any database product, technology or schema that has been inherited, is outdated or has to be worked with because of historical or compatibility reasons.

Use this tag for questions where you want to indicate use of database product, technology or schema that has been inherited, is outdated or has to be worked with because of historical or compatibility reasons. Question examples:

128 questions
0
votes
1 answer

New Rails app drawing some data from legacy tables

I have a new rails app which needs to access data from a legacy table called "Doo_dad", with an autoincrementing primary key called "id", and a string field called "name". So I created a new model file called app/models/doodad.rb which looks like…
Jay Godse
  • 15,163
  • 16
  • 84
  • 131
0
votes
1 answer

Porting to Django, Support for legacy user database

I am porting my website from raw php to Django. I have used inspectdb to create models for the existing database. The problem that has come is that earlier I was registering the users and saving their passwords as a md5 hash md5($pass) and Django…
Sachin
  • 3,672
  • 9
  • 55
  • 96
0
votes
0 answers

How to make sure the springboot API is not putting load on the database

Hello am trying to design an RestApi using latest springboot and Java 17. The existing database is pretty old ,cannot handle multiple simultaneous request. I thought of below ideas Caching Rate limiter (guava) but it is not reliable it seems Is…
anna storyofmylife
  • 1
0
votes
1 answer

Django how to add a model instance with a foreign key field if the referenced model instance does not exist

I am working with a legacy database within an AS400 system connected to my Django project. I am trying to configure my models in the best way possible and set up relationships correctly but I am running into an issue related to adding an instance of…
Floris Kruger
  • 74
  • 8
0
votes
1 answer

Legacy File Schema - Reverse Engineering

I'm currently in the process of converting over 20k database tables from Corel Paradox 4.0 format (DOS Based, with a .db extension) to SQL databases, and rather than using off the shelf software, I'm currently looking into using a light scripting…
theonlylos
  • 173
  • 1
  • 10
0
votes
0 answers

Rewrite legacy php-native code to Laravel with no downtime

I'm working in large app that have below module where every module have relation each other, the module is: Fiance Production Plan Laboratory This app written in really-really php-native code with many security concern. I'm trying to rewrite it to…
Abu Dawud
  • 11
  • 5
0
votes
2 answers

Count Group By and Separate If Included in Both Group

Not sure if this question is duplicated yet or not. I have a simplified table below User Interest Jason Art Jason Sport Sam Sport Sam Art Steve Sport Desmond Sport Tania Art Here's the result that I want to…
Rama Ramadhan
  • 37
  • 6
0
votes
1 answer

postgreSQL 8.4.20: How to solve missing oldestXID in pg_control preventing use of pg_upgrade on a legacy CentOS 6.4 server?

My company has a legacy, internal server running CentOS 6.4 with postgreSQL 8.4.13. The goal is to upgrade it as far as possible without doing OS updates; it's a live internal server being used for services, so it's not practical to upgrade the OS…
Scott
  • 11
  • 2
0
votes
0 answers

Connect django to legacy postgresql database, already exist and have 1 table

am trying to connect postgresql database with a table already created (legacy). Not much documentation on the Internet to do so as the database already created. Am afraid to lose the data. Any guide to do that. Am using Windows and gitbash and have…
Ab6578
  • 15
  • 3
0
votes
0 answers

How to access a legacy database without creating a new table in it in Django

I was given access to a database to use on one of my Django projects. I set everything up and went to migrate the new models and I got an error. "Unable to create the django_migrations table ((1142, "CREATE command denied to user 'MyDatabaseName'…
RiotF
  • 71
  • 5
0
votes
1 answer

Django running migrations on legacy database

I am working with a legacy database and I have created a custom user model. I am working to set up the register and authentication funcs. I have created the user manager and in user model there are some fields that I have added for django like…
kakakakakakakk
  • 467
  • 10
  • 31
0
votes
1 answer

Migrate to LINQ To SQL or Entity Framework

A legacy database project was built as SQL DataSets (80 DataTables with about 1000 Functions). Now we are modernizing the project to better technology. What concerns of choice to migrate to Linq2SQL or EF. PS. We don't want to re-write the entire…
Adham Enaya
  • 780
  • 1
  • 11
  • 29
0
votes
1 answer

Make ActiveRecord append some SQL automaticly

[updating question to clarify] Can I create a model in Rails 3/3.1 and make ActiveRecord automatically use/append some joins I configured to that model? Ex: Use code like this: class Component < ActiveRecord::Base def self.base_query …
Celso Dantas
  • 1,181
  • 10
  • 14
0
votes
1 answer

django rest framework apis using legacy db without creating django default tables

I am going to develop django rest framework apis using postgres legacy database in which apart from the existing tables no other default django tables should be created. I would like to know without creating any django default tables or doing…
User123
  • 793
  • 4
  • 10
  • 28
0
votes
1 answer

Working with composite primary key and foreign keys in django project with legacy database

In this question, e4c5 suggests updating tables in the legacy database with a single primary key to work with Django. However, every table referencing the updated table will be using the composite primary key as reference and will therefore not work…
Kasper Skjeggestad
  • 135
  • 1
  • 11
1 2 3
…
8 9