For large persistent databases, it is also effective. For speed, please pay attention to commit large transactions instead of each key.
< p>The suggestion and proper use of sqlite as a data storage area are explained on its website: http://www.sqlite.org/features.html
I’m just curious , If anyone can tell me whether using SQLite to store dictionaries (like brute force) for Python scripts is an effective method. Although I am relatively new to Python, I have a lot of experience with other programming languages, and I am currently using Backtrack The testing tool used in the .So far, I am impressed with the speed and simplicity of Python, and my SQL queries seem to ideally return the required prefixes for my brute-force tool. However, I think what I want to know is in What is the standard for storing large data files in Python? Am I neglecting a better (faster) way of storing my prefixes because of my comfort with SQL? Please keep in mind that instead of using Python to query IDs 0 to n and use them, I use Python to narrow down the possibilities and query matching dictionary entries. Any help or comments would be greatly appreciated!
Yes, sqlite is a reasonable choice to implement a dictionary. To get speed, use: memory: option, and make sure to create appropriate indexes for lookups and queries.
For large persistent databases, it is also very effective. For speed, please pay attention to commit large transactions instead of each key.
Suggestion and proper use of SQLite as a data storage area There are instructions on its website: http://www.sqlite.org/features.html