# Real-Time Data Transfer from PostgreSQL to MySQL **URL:** \ **Category:** Async/Channels\ **Created:** [February 29, 2024, 9:46pm UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569 "2024-02-29T21:46:43Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![englewood6](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/englewood6/32/19537_2.png) [@englewood6](https://forum.djangoproject.com/u/englewood6)\ **Post date:** [February 29, 2024, 9:46pm UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/1 "2024-02-29T21:46:43Z")
I have two machines: Industrial PC (IPC) which has W10 and my laptop which has a Ubuntu-Linux running on a VM Databases: IPC has Monorepo/PostgreSQL data from the automation line My Django has mySQL. When I plug an ethernet cable from my laptop to IPC, the PostgreSQL data starts to flow into my models.py in my monorepo app. Problem is: Whenever Industrial PC (IPC) produces timestamps, I’d like to fetch those data and display on the web. I’d like to do data transfer from PostgreSQL to MySQL. When the ethernet cable plugged, I am able to retrieve those postgreSQL data via Python Shell. I am planning to do use Django Signals to get notification that the data is received from my monorepo models. And then I am planning to handle those data using Celery, Channels and WebSockets, and I aim that whenever postgreSQL produces data I need, I’d like to see them on the specific section of the specific page without refreshing page. What would be the steps to implement? In addition to this, do I need a specific database driver for data transfer between two databases such as mysqlclient and psycopg2? DATABASES = { ‘default’: { ‘ENGINE’: ‘django.db.backends.mysql’, ‘OPTIONS’: { ‘read\_default\_file’: ‘/etc/mysql/my.cnf’, }, }, ‘MICE’: { ‘ENGINE’: ‘django.db.backends.postgresql’, ‘NAME’: ‘app’, ‘USER’: ‘postgres’, ‘PASSWORD’: ‘pass’, ‘HOST’: ‘x.x.x.x’, ‘PORT’: ‘5432’, ‘POSTGRES\_NAME’:“postgres”, ‘POSTGRES\_USER’:“postgres”, ‘POSTGRES\_PASSWORD’ : “pass”, } } ---
**Author:** ![KenWhitesell](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/kenwhitesell/32/280_2.png) [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)\ **Post date:** [February 29, 2024, 10:47pm UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/2 "2024-02-29T22:47:13Z")
Have you worked your way through [the official Django Channels tutorial](https://channels.readthedocs.io/en/latest/tutorial/index.html)? If not, that’s your best place to start. The Chat application really is a good analogy, if you consider the data source as being the sender of the chat messages and your display application being the recipient of those messages. Once you’ve worked your way through the tutorial to the point where you understand what everything it doing, then you’ll be in a really good position to implement your process. > [@englewood6](#): > > I am planning to do use Django Signals to get notification that the data is received from my monorepo models. That’s probably the worse thing to try and use here. If you’re going to use Channels, use it all the way through. ---
**Author:** ![englewood6](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/englewood6/32/19537_2.png) [@englewood6](https://forum.djangoproject.com/u/englewood6)\ **Post date:** [March 1, 2024, 1:30am UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/3 "2024-03-01T01:30:12Z")
Hi Ken, I really wanted to get feedback from you. I appreciated that. Okey, I’ll look at that Django Channels tutorial. I will also remove Signals as recommended. But I think that’s not the whole point. At the end, I will need to fetch many data(attributes) from many models. These real-time data will be put in some specific sections or cards. That’s why this leads me to think about fetching data and processing them periodically using Celery. I imagine that I’ll have massive tasks.py for that. I’d like to get your feedback about the use of Celery for this task. And also, do you see any extra database configuration related to mysqlclient and psycop2? ---
**Author:** ![KenWhitesell](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/kenwhitesell/32/280_2.png) [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)\ **Post date:** [March 1, 2024, 1:35am UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/4 "2024-03-01T01:35:37Z")
> [@englewood6](#): > > I’d like to get your feedback about the use of Celery for this task. I’d need a lot more specific details about your requirements to even begin to think about offering suggestions. (General terms such as “many”, “some”, “periodically” have different meanings to different people.) > [@englewood6](#): > > And also, do you see any extra database configuration related to mysqlclient and psycop2? Django works quite well with multiple databases. See [Multiple databases | Django documentation | Django](https://docs.djangoproject.com/en/5.0/topics/db/multi-db/) ---
**Author:** ![englewood6](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/englewood6/32/19537_2.png) [@englewood6](https://forum.djangoproject.com/u/englewood6)\ **Post date:** [March 1, 2024, 1:46am UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/5 "2024-03-01T01:46:46Z")
When the LAN connection is on, PostgreSQL sends real-time data from the automation cell to my common model’s attributes, such as date\_started, date\_done, and command. The first two are timestamps, whereas the command (integer field) specifies the specific process. If it is 1, the timestamps needs to go to that specific process. What I want is this: Whenever postgreSQL produces timestamps (or any data), I’d like to see them on the process card without refreshing the page.This is actually the foundation of my requirements. ---
**Author:** ![KenWhitesell](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/kenwhitesell/32/280_2.png) [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)\ **Post date:** [March 1, 2024, 1:49am UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/6 "2024-03-01T01:49:52Z")
What specifically and technically, do you mean by: > [@englewood6](#): > > PostgreSQL sends real-time data from the automation cell to my common model’s attributes How does PostgreSQL _send_ this data? > [@englewood6](#): > > Whenever postgreSQL produces timestamps (or any data), How does PostgreSQL _produce_ this data? ---
**Author:** ![KenWhitesell](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/kenwhitesell/32/280_2.png) [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)\ **Post date:** [March 1, 2024, 2:34am UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/8 "2024-03-01T02:34:39Z")
First a side note: You need to enclose the code between lines of three backtick - ` characters to maintain the proper formatting. (I fixed this for you on this post.) Unfortunately, this code, without any context, doesn’t help at all. (This also doesn’t appear to imply PostgreSQL doing anything at all as part of this.) Please provide an actual description of what you’re trying to do, with enough of an explanation of what the components involved are to be able to understand what the source and destination of data is at each step. ---
**Author:** ![englewood6](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/englewood6/32/19537_2.png) [@englewood6](https://forum.djangoproject.com/u/englewood6)\ **Post date:** [April 30, 2024, 7:35pm UTC](https://forum.djangoproject.com/t/real-time-data-transfer-from-postgresql-to-mysql/28569/9 "2024-04-30T19:35:55Z")
Why did you think that the usage of Django Signals would be the worst thing in this issue? Both devices have databases and codebases. PostgreSQL produces data when the automation cell is running and whenever it produces data, the goal is displaying that in the web in real-time. Does Django Signals notify us that we have that? I’d like to know: What would be your approach to this issue? Channels are fine. The problem is acquiring data. Would you create models for that incoming data and store them? Which file should handle the incoming data from PostgreSQL first? Would you directly handle them with Celery tasks.py?