Databases
StackOverflow2013
Postsdbo
POUploading and loading images through jquery ajax
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUploading and loading images through jquery ajax
    primarykey
    data
    text
    <p>So, let me explain it better, I'm pretty sure the title doesn't says much.</p> <p>I'm in charge of doing some improvements on the company system. Now the system saves the current image, as a file, and insert into the database the path of the image.</p> <p>Then, what's the problem if it works? Well, if the server gets a lot of images being inserted all the time, the server will need some improvements, so my first thought was, why don't I save the image data to the database and load it through ajax call? That's nice, it won't make the server overload from lots of gigabytes from the images, won't have problems with duplicates and such, but when I call the ajax method from jQuery, the data sent to the server side is via query string and if the data is higher than 6000 characters, like most are when I use base64 encoding, I can't call the method.</p> <p>My other thought was, send the image to the server side and then generate the data to save to the database, and when the user wants to see the image, the server transform the data to an image and sends to the client side. But the problem is, there are lots of users for this system, and sending/receiving lots of images will make the server get memory problems due to the high amount of requisitions.</p> <p>So to make long story short, what is the best way to send/receive images from client to server and the opposite without overloading the server capacity.</p> <p>P.S.: Sorry for the long post, I wanted to make a clear question.</p> <p>Thanks in advance.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAndré Silva
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUploading and loading images through jquery ajax
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POUploading and loading images through jquery ajax
      1. This table or related slice is empty.
      1. VTUpMod
    1. COimages in the database are almost always a bad idea, and sending everything out as base64 will boost your bandwidth bill by ~33%. Store the images in the file system and just store the image's PATH in the database, then you can load them trivially with a standard `<img>` tag.
      singulars
      1. POUploading and loading images through jquery ajax
      1. USMarc B
    2. COFirst of all, thanks for the fast answer, and second, do you think it's worth to compress the images when I save on the server-side to reduce the amount of space on the hard-drive? It's a 24/7 system that constantly exchange images between server/client, so it will overload a bit the server, I guess.
      singulars
      1. POUploading and loading images through jquery ajax
      1. USAndré Silva
    3. CO@MarcB: an imporant addition would be to note that images should NOT be saved directly in the physical folder of the web application. Rather, you save them to a separate share and expose through an url facade, possibly handled by a separate server. If done properly, this increases security and performance.
      singulars
      1. POUploading and loading images through jquery ajax
      1. USWiktor Zychla
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload