json - Storing zipped string into sqlite database using python -


I am trying to store a compressed dictionary in my SQL database. First of all, I change the dict in a string using json.dumps , which works fine. Storing this string in DB also works.

In the next step, I am compressing my string using the encoding ("zlib") . . But throws an error in storing the resulting string in my DB 

  mydict = {"home": "haus", "cat": "katze", "red": u'w \ Xe4yn ', "dictionary": {"1": "asdfhgjl ahsugoh", "2": "s dhgsuoadhu gohsuohgsduohg"}} dbCommand ("creating table testTable (ch1 varchar);") #changed string for jch1 = json .dumps (mydict, sure_ascii = true) print (jch1) # store uncompressed values ​​dbCommand ("insert in testTable (ch1) values ​​('% s'),"% (jch1)) # compressed json wire cjch1 = jch1.encode ( "Zlib") print (cjch1) # store compressed values ​​dbCommand ("t The first print output:  
  {"home": (% 1) values ​​in the estTable (ch1) values ​​('% s'); "% (cjch1))  
 
 "Haus", "Glossary": {"1": "asdfhgjl ahsugoh", "2": "s dhgsuoadhu gohsuohgsduohg"}, "red": "w \ u00e4yn", "cat": "katze"}

The second print is definitely not readable: 

  X ワ フ 1 テ PC ㄿ ㅤ YF ネ ノ Õ

Looking forward to any help signal!

Let's approach this from the back: Why are you using GGIP encoding in the first place? Do you think you need to save space in your database? Have you checked how long the strings will be in production? Compression In fact, these stars will need a minimum length before saving storage space (small input can be bigger than output input for string!). If he really saves some disk space: Do you think that the additional CPU load and processing time saved due to GPIP encoding and decoding?

In addition: The result of gzip / zlib compression is a binary blob in Python 2, this type should be of str in Python 3, type byte Should be. In any case, the database needs to know that whatever you are storing is binary data ! For this endeavor, VARCHAR is not the correct data type. After this, there is a quote from MySQL docs:

In addition, if you use binary values ​​from encryption or compression function If you want to store, which may contain arbitrary byte values, then use a Blob column instead to avoid potential problems with a CAR or VARAR column, which changes the space values.

The same idea is correct for other databases Additionally, in the case of SQLite, you should use the BLOB data type (see) to store binary data (if you already have You want to be sure to retract the exact data held: -)).


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more