Luca, bu using slugs in your URLs instead of database IDs you completely remove this problem, as well as making your urls nicer and better for SEO.
A question for people with good experience with OrientDB, what is the performance implications with using slugs over rids if the slugs are indexed? Should I take care to keep a slug to rid mapping in for example redis so that queries to OrientDB always uses rids? On Wednesday, January 28, 2015 at 12:43:21 AM UTC+1, JR wrote: > > Thanks Riccardo, > > good point! do you know how others are solving this problem? I'm planning > to use OrientDB as my only storage solution. > > Thanks a lot, > Luca > > On Tuesday, January 27, 2015 at 3:39:54 PM UTC-8, Riccardo Tasso wrote: >> >> Yes Luca, >> >> consider also if you use rids in your URLs. For example: >> http://myapp.com/details.jsp?rid=1:1 >> >> In this case if someone links to your URLs it could be a problem. >> >> Cheers, >> Riccardo >> Il 27/gen/2015 21:29 "Luca Rondanini" <[email protected]> ha scritto: >> >>> Hi Andrey, >>> >>> just to double check, if I use RIDs in my web app everything should be >>> fine. Inserts/updates won't change any RIDs. Problems may raise if, for >>> example, I'm storing RIDs in MySQL as reference. If then, I export and >>> reimport the data in orientDB the RIDs may be changed and the MySQL data >>> won't reference the right rows anymore. >>> >>> Can you confirm? >>> >>> Thanks, >>> Luca >>> >>> On Monday, January 19, 2015 at 5:28:16 AM UTC-8, Andrey Lomakin wrote: >>>> >>>> Hi Bertran, >>>> The only issue is that if you do export database to JSON and then back >>>> your RIDs will be changed. >>>> But may be we will add option to keep rids on their places. Not so hard >>>> to do. >>>> The only downside of such flag will be presence of holes for rids of >>>> removed records. >>>> Each record removal consumes about 10 bytes of disk space (not so much >>>> )) ), but when you do export/import we optimize space is used by database >>>> as result rids may be changed. >>>> >>>> On Mon, Jan 19, 2015 at 2:48 PM, Bertrand Quenin <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> I'm currently using OrientDB for a project at work and I have some >>>>> question about record IDs. >>>>> >>>>> As far as I understood, record IDs are unique and can be used to to >>>>> identify a record in a deterministic way. I was wondering if these IDs >>>>> can >>>>> be used to identify objects through (REST) APIs. >>>>> >>>>> As any web application, I need to identify objects one way or another >>>>> and I was wondering what the best approach would be: >>>>> 1/ Using record IDs provided by orient DB >>>>> 2/ Adding a "business" id field to my objects and manage it aside. >>>>> >>>>> So far, I didn't see any reason why I shouldn't use the record ID >>>>> itself, the only con I see is that RID are strings clusterId#position >>>>> (and >>>>> not plain integers) and it's a bit harder to expose in an URL ... >>>>> >>>>> Is there any issue I haven't foresee ? >>>>> >>>>> Thanks for your help >>>>> >>>>> -- >>>>> >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "OrientDB" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> >>>> >>>> -- >>>> Best regards, >>>> Andrey Lomakin. >>>> >>>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "OrientDB" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
