Thanks, Massimo! It's a nice and easy trick. I'll implement it as soon as possible.
Le lundi 18 mai 2015 19:24:21 UTC+2, Massimo Di Pierro a écrit : > > The usual trick is to generate URLs like > > https://domain.com/blog/145/this-is-an-article > <http://domain.com/blog/this-is-an-article> > > where 145 is the id. The slug is just for show. > > On Monday, 18 May 2015 12:10:37 UTC-5, Jean-François Milants wrote: >> >> I found out that what I'm trying to do is a 'slug', a unique name for all >> of my posts. >> However, I'm worried about the performances of the search of the post in >> DB. >> >> For example, when the user will enter this URL : >> https://domain.com/blog/this-is-an-article >> >> A request will be made in DB to search for the string 'this-is-an-article >> <http://domain.com/blog/this-is-an-article>'. This should'nt be an issue >> for a small DB, but this could become a bottleneck when the DB will grow. >> >> How do you guys implement such a thing? >> >> >> >> Le samedi 16 mai 2015 16:41:36 UTC+2, Jean-François Milants a écrit : >>> >>> Hi, >>> >>> I'm writing a blog application, which allows me to create new blog post >>> and have them listed on a page. >>> >>> In database, I have a table called "articles" which contains some field >>> (id, title, content_text,...). >>> >>> For now, the URL to access to a specific blog post has the following >>> structure : >>> >>> https://domain.com/blog/readArticle?articleId=23. >>> >>> Where : >>> >>> - Blog is the controller >>> - readArticle() is the function that retrieves the blog article data >>> - 23 is the ID of the article in the DB >>> >>> >>> This is easy to implement, but no user/SEO friendly. >>> >>> I would like to improve the URL structure to something like: >>> https://domain.com/blog/readArticle?article=this-is-an-article >>> >>> or >>> https://domain.com/blog/this-is-an-article >>> >>> ... and I'm looking for the best way to do this. >>> >>> Should I modify my backend so that it will search the article based on >>> its title (or 'slug'). >>> Or should I use the 'router' in some advanced ways? >>> >>> I'm sure a lot of people has already done that. Any ideas or suggestions? >>> >>> Thanks! >>> >>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" 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.
