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.
