title,body,link,tags,view_count,is_answered,score,answer_count
MS access based application / db testing using jmeter or loadrunner,"<p>May i ask if anyone have done any concurrent user test for ms access based db/application. I understand that it is not a typical client / server architecture however still wondering if any method available to simulate multiple users. Thanks</p>
<p>no information available</p>
",https://stackoverflow.com/questions/75886640/ms-access-based-application-db-testing-using-jmeter-or-loadrunner,"['ms-access', 'performance-testing', 'jmeter-plugins', 'loadrunner']",49,False,0,3
Deserializing image from DB,"<p>I'm trying to store an image into a database as a <code>BLOB</code>. So I need to serialize and deserialize it after retrieving back from DB. Testing out serializing/deserializing steps without DB works fine but deserializing the data from DB not. I've tried many different ways like the 3 shown, with <code>as.data.frame</code> and many more. Problem occurs with MariaDB and SQLite as well. Datatype in DB is <code>BLOB</code> for SQlite and <code>LONGBLOB</code>, <code>MEDIUMBLOB</code> for MariaDB. So I don't think this has anything to do with the used database as long as the type is <code>BLOB</code>. Thx for any help.</p>
<pre><code># 1. Loading image + serializing it
pb &lt;- readBin(paste0(&quot;S:\\File.png&quot;), what=&quot;raw&quot;, size = NA_integer_, endian = .Platform$endian, n=1e6)
pbSer &lt;- serialize(pb, NULL)

# 2. Storing it in DB (Code is for MariaDB)
query &lt;- paste0(&quot;REPLACE INTO Images (Name, Image) VALUES &quot;, &quot;(\&quot;&quot;, &quot;pbSer&quot;, &quot;\&quot;, \&quot;&quot;, list(pbSer), &quot;\&quot;)&quot;)
dbExecute(con, query)

# 3. Retrieving data
rows &lt;- dbGetQuery(con, paste0(&quot;SELECT * FROM Images WHERE Name = \&quot;pbSer\&quot;&quot;))

# 4. Unlisting and deserializing
pb2Ser &lt;- unlist(rows$Image)
pb2 &lt;- unserialize(pb2Ser, NULL) # -&gt; Error in unserialize(pb2Ser, NULL) : unknown input format

# Two more versions I've tried
pb2Ser &lt;- as.raw(unlist(rows$Image))
pb2 &lt;- unserialize(pb2Ser, NULL) # -&gt; Error in unserialize(pb2Ser, NULL) : unknown input format

pb2Ser = as.raw(as.integer(paste0('0x', pb2Ser)))
pb2 &lt;- unserialize(pb2Ser, NULL) # -&gt; Error in unserialize(pb2Ser, NULL) : unknown input format
</code></pre>
",https://stackoverflow.com/questions/75297862/deserializing-image-from-db,"['r', 'database', 'image', 'serialization', 'deserialization']",73,True,0,1
