New words/quotes keeper

[blackcat]

I've been looking for this type of software for a long time but I haven't found one that doesn't either bog down my system with bells and whistles that I would never have a need for or want me to pay for 50 bucks for something that does a simple job like this.

I just need it to be small and simple to use, and uses sqlite to store data. Having support for basic rich text format like bold, italic and underline would be nice. I could probably whip you up a gui mock-up how I want the app to look like later  

I imagine this would also be very useful for language learner or people that need a systematic way to keep and organize their collection of new words they just learned.

[rjbull]

You might look at mouser's own Clipboard Help+Spell, which uses SQL.  If you do, take a look at this thread Feature request: Web clipping, permanent note keeping where IainB discusses how he uses it as a PIM/outliner.

If it doesn't absolutely have to be SQL, I'd suggest AZZ Cardfile, which has a very nice "find as you type" feature, or the similar-looking Notefrog.  AZZ has been around quite a while but the author seems to have disappeared; the current version has minor problems on late-model Windows, but there's a workaround in one of their threads, “The Program has Changed, Reinstall” Message

[IainB]

You might look at mouser's own Clipboard Help+Spell, which uses SQL.  If you do, take a look at this thread Feature request: Web clipping, permanent note keeping where IainB discusses how he uses it as a PIM/outliner.

Yes, I would see the excellent CHS as being useful for this, amongst its multifarious uses.    
Rather than just Copy the new vocab item (a word or expression) into the clipboard (and simultaneously into CHS), it would probably be best to enter/paste the item into CHS via the "Add a Quick Note" function in CHS (I use the Ctrl-Alt-Z hotkey combination to pop up the small window for this).

The "Add a Quick Note" function would be best because it flags the item as a "Favorite" by default (so it will be retained permanently in the database and not automatically/periodically purged as old data).
If you also entered a term such as, for example, "vocab" anywhere in the "Add a Quick Note" popup window, then that term could be used as an SQL search string in a Virtual Folder in the CHS Favorites treelist.
Here's an example of using it this way:
[attach]

[rjbull]

FWIW, the last free version of AZZ Cardfile is at the bottom of their azzCardfil Downloads page.  It should give the flavour.