Hi - I’m spending an enormous amount of time getting everything migrated over to Wix and I have a question for this forum… I use SQL on a Windows Platform and I want to use Wix Database so I don’t have to go back and forth every time I need to get things done. I have over 75,000 records thus far and just wanted to know, is it a good idea to migrate this over to Wix Database and can it handle it? Please excuse my ignorance on this and thank you so much
1 Like
Hi
The experience I got so far (simple tables, no joins or complex queries, few hundreds of rows, no dev-to-production schema change to perform) is that it works fine as long as you do not need to perform batch operations on your database (like massive update or deletes) with good performance, for you can only perform row-by-row update/delete.
Jerome, please do keep in mind that the database part of Wix Code is based upon MongoDb, a so-called noSQL db. Every advantage and disadvantage that noSQL databases have in comparison to SQL-db also go for Wix Code. There are some good articles to be found on Quora and Stackoverflow about which db to choose for which job. But if you need transactions (master/detail, like purchase order, invoice, general ledger, hotel reservations, time-and-billing) and ACID-compliance, if you need auto-increment (order#, invoice#, reservation#, etc) or if you need row-locking, then MongoDb (thus Wix Code) is usually not a good idea. If you are building the next FaceBook, where 1179 likes actually should be 1181, but nobody cares, then use MongoDB, thus Wix.
Also keep in mind the well-documented problem with floating point handling in Javascript: do not be surprised if you write USD 100 to a row and when you read it back, it holds 100.000001!
It simply depends on the type of project you are doing if db A or B should be used.
Good luck.
Hummmm, OK … Let me do something I saw someone else do in another forum. I’m going to provide a live version of what I’m talking about because I know my terminology is terrible ( please excuse me ). OK, here it goes.
please visit http://moecom.net/ordermusic.asp – give it a minute, it has to wake up. ( i hate that )
login using “moe” as the username and “moe” as the password
If you can take a look at that and tell me if Wix database can handle that, that would be great. Let me know what else I can do. I am so appreciating this… I’m so grateful!
hmmm, I would like to find out if Wix db is used for this specific purpose, exactly what can go wrong in this example irl terms?
Hi Moe,
can you point out a more specific issue i can help with?
Shlomi
Moe, had a look at your site. The short answer is: I am not sure if this is possible. The longer answer is:
- as far as I know, Wix Code does not allow the file type mp3 (only images and docs). So the preview feature would be hairy, if not impossible;
- you will need some kind of integration with Wix Stores to be able to do that (I believe Wix Stores allows digital goods to be sold)
- but how to convert all your db-info into Wix Stores Collections and Items, really, I do not know: as far as I can see everything is read-only from the Wix Code side, but maybe wix Stores has some kind of import tool, I know little to nothing about Wix Stores
I know this is not helping you much, but it´s the best I can do.
Giri - Check this out… I was able to get a database imported using Excel CSV file. Wix allows a link as one of their options for what kind of field you want… I chose URL and I’m able to provide song samples to the user. All I need to figure out now is, create a user input check button for them to choose … Take a look…
https://www.gomightymoe.com/music-database
shlomi - how do i create a database in wix that allows users to make selections and send that data to me. Someone just helped me with that line… All input are welcome
Giri - Images and Docs is all I need… I need need the users to be able to choose from it and send that data to me… I can do the manipulating of the data from there with the mp3s
Moe, I see: you keep all data on Wix, but the mp3´s on a different server with a url to it. Yes, you can do that. You could prob. even make a lightbox with an html-frame inside, and send the URL to the html-component , where on the html-side, you choose any player to play this song.
Now, for the clicking and the marking which songs they chose, you will need some creative tinkering: the grid does not allow input elements (and neither does the Repeater), so you might want to try to add a unbound image to the grid, default to “not selected” and on the onClick swap the image to “selected”.
But you will have to keep track somehow what they selected. You can write that to an ordering collection or store it in local memory (not advisable), but remember that id they unclick, you will have to remove the row (or at least set a flag).
YESSSSSSSSSSSSSSSSSSS… whewww! -
Would it be better if I used like a 3rd party cart for Wix that would hold that info. I’m looking at the apps now to see I can incorporate that.
OK, I won’t bother you anymore… I so appreciate your help with this… I’m getting better…
Good on you. As for the other 2 points I mentioned before (no ACID, Javascript floating point) the following:
- if you write every clicked item directly to a row, you only run a small risk of data-inconsistency on the first item, since there you have to write the Main row (order date, client Id, order number [or use _id, which would give you something similar to what you have now)] and the first detail row (ref to Main, item, price, etc). Every add/delete from then on is just one write
- the floating point thing starts to bite with a lot of items. If you want to stay on the safe side, use the age-old trick of multiplying the price by 100 and when retrieving, divide it by 100.
Good luck.
A million Thanks!!!