Will SQLite work fine for this?

I am working on a small app that will need a database, I was thinking about using sqlite but I am worried about if its going to do the job right and mainly about speed.

I will have a table with columns like: id - keyword - link1 - link2 - link3

And I will need to run queries like 'select * from table where link1 = ""' and also '---link1 LIKE '%something%'

I would have from 5k to 50k entries on each database (i开发者_高级运维 will use multiple dbs).

Will SQLite work fine for this type of queries or it can get slow for this amount of entries?

SQLite has a pretty old speed comparison test on their site. It's a bit dated, but still pretty relevant as neither PostgreSQL nor MySQL have made any major barrier breaking improvements in their speed.