I have some ideas that I want to put in a script but don't know we're to start. Any tips/advice

There are a few things you could mean by script (using the API, userscript, perhaps something with the database export). It's hard to really give any advice that applies to all, aside from things as generic as "you should know at least one programming language".
If you do want to use the API, https://e621.wiki/ is helpful.
If you have something specific you want to do, I could give an example.

I can't really say which one, I kind of just had some ideas for functionality I want to try to make for myself (and maybe other people to use). So I guess a user script. I kind of don't know the difference between a user script and using the API. Sorry don't know to much at programming. I was going to use this as a project to motivate me to learn

cloud2313 said:
I can't really say which one, I kind of just had some ideas for functionality I want to try to make for myself (and maybe other people to use). So I guess a user script. I kind of don't know the difference between a user script and using the API. Sorry don't know to much at programming. I was going to use this as a project to motivate me to learn

Well, you can make a "User Script"(An script for the user to.... use) using the API, since an script it's just a extensional program to be used alongside something (Such as a Compiler or Scripting Engine).

I don't know how the User Script works here, but from what i've heard, people normally use those injected with TamperMonkey to add functionalities to the site (Such as: RE621) (personally, i don't like it this way)

When using the API, you may choose a programming language and call directly to the site for retrieving data and parse it with your application.

A programming language allows you to create scripts (js, py, cs), those can fetch an specific tag and its posts after a period of time (once, twice, thrice a day for instance), mass downloading, fetching favorites and many more things.

For an instance, i use C# + E621Client by Noppes to develop both "PURR" and "PURR->NEXT", the latter is a full application for fetching E6 posts but you could simply make a single CS (C# file) with code for fetching only your favorites and put it in a folder alongside an extra file for your creds (if needed) and schedule it to be called once a day, boom, automized favorite fetching.

Aside of C# (which has a very good framework for this) using JS (Javascript) and Python shouldn't be that much different from C# and even has an example in the WIKI

Hope this helps you and my apologies for talking so much >w<

Edit: Corrected some grammar mistakes, my apologies.