Python Forum
Python Forum

Database that can compress a column, or all data, automatically?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Database that can compress a column, or all data, automatically?
ibreeden
Verb Conjugator
Posts: 582
Threads: 1
Joined: Aug 2019
Reputation: 56
#2
May-16-2023, 07:54 AM
I believe SQL Server can store data compressed, but I have no experience with it.
But why don't you just compress the JSON with the gzip or zlib modules and then store it in your database? Of course you wil have to store the compressed data in a BLOB-type column.
Find
Reply


Messages In This Thread
RE: Database that can compress a column, or all data, automatically? - by ibreeden - May-16-2023, 07:54 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python script to extract data from API to database melpys 0 1,105 Aug-12-2024, 05:53 PM
Last Post: melpys
  Returning Column and Row Data From Spreadsheet knight2000 0 1,174 Oct-22-2023, 07:07 AM
Last Post: knight2000
  How to detect abnormal data in big database python vanphuht91 5 2,530 Jun-27-2023, 11:22 PM
Last Post: Skaperen
  Code for pullng all data in a column EmBeck87 5 2,206 Apr-03-2023, 03:43 PM
Last Post: deanhystad
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 3,358 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  split txt file data on the first column value shantanu97 2 3,682 Dec-29-2021, 05:03 PM
Last Post: DeaD_EyE
  Retrieving a column from a data set using a function Bayle 6 4,414 Oct-06-2021, 08:52 PM
Last Post: Bayle
  I need help parsing through data and creating a database using beautiful soup username369 1 2,408 Sep-22-2021, 08:45 PM
Last Post: Larz60+
  Python Pandas: How do I extract all the >1000 data from a certain column? JaneTan 0 2,179 Jul-17-2021, 09:09 AM
Last Post: JaneTan
  SaltStack: MySQL returner save less data into Database table columns xtc14 2 3,115 Jul-02-2021, 02:19 PM
Last Post: xtc14

Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020