So, I built a search engine. It’s real. It crawls the web and fetches metadata about a page and stores it, allowing you to search for it later. No APIs, just Glitch. it uses your browser to search through the data as using Glitch would be memory/CPU intensive.
I’m using some package (forgot name) and metadata does not only have to from from Metatags. For example, https://example.com does not have any metatags, but the engine is still able to get metadata from it.
Use NoSQL databases, like Firebase or Deta Base or IndexedDB. Or if you’re still persistent on using SQL, use a database adapter like https://endb.js.org to make your life easier.
The reason one would not use something like jsoning is because it’s not efficent enough for them.
Jsoning may or may not load all it’s data into memory which is not optimal. The real inefficiency may come when there is a larger amount of keys so in the worst case it will take O(N), where N is the total number of keys. SQL and NoSQL databases have a ton of optimizations and complex data structures which is why most bussiness use them
Any DB can get corrupted. The reason I switched to MongoDB was because it had free managed hosting by the people who made it. Where as in MySQL, you are at the mercy of yourself or an unreliable host. So far the only free hosting I have found is RemoteMySQL (You can only use 100 mb of data and you don’t get access to a full database, rather just 1 db on a server that is shared with other people.) and 000webhost.
PHP is actually good now. SQL is a good, solid, useful language, and it has many stable, refined, implementations. It is mostly portable, which you can’t claim for most nosql databases.
Yeah, for my sql apps, I can start small from sqlite and move to mysql, postgresql, mssql if needed to scale up
You only have the mongodb server/clusters which in most cases, cannot run on glitch
The filter doesn’t work - https://searchit.glitch.me/search?q= shows adult content.
Edit: i think you should scan the source of the site for bad words and if it appears don’t add it.