Tutorial How to properly and parse DBs fast?

Tutorial How to properly and parse DBs fast? - Printable Version

+- Sinisterly (https://sinister.ly)
+-- Forum: Hacking (https://sinister.ly/Forum-Hacking)
+--- Forum: Tutorials (https://sinister.ly/Forum-Tutorials)
+---- Forum: Requests (https://sinister.ly/Forum-Requests--826)
+---- Thread: Tutorial How to properly and parse DBs fast? (/Thread-Tutorial-How-to-properly-and-parse-DBs-fast)

How to properly and parse DBs fast? - Zayzo - 12-23-2015

Hi guys, I was just wondering how I can parse dbs in a fast way.

Thanks.

RE: How to properly and parse DBs fast? - meow - 12-23-2015

Table/column indexing, using the correct table/column types, and just having a good CPU.

RE: How to properly and parse DBs fast? - Zayzo - 12-24-2015

Yeah but I mean like, instead of having to import export everything on phpmyadmin just having a program that would be able to do it. Which would be nice for bigger dbs.

RE: How to properly and parse DBs fast? - Zayzo - 12-24-2015

(12-24-2015, 02:21 PM)Retro Wrote: I'm unsure as to what you're trying to accomplish, if you want to grep users credentials use AstroGrep.

Making big clumsy dbs smaller by only having username:hash Confused

alt:email:ip

instead of 0,`, `,etc

RE: How to properly and parse DBs fast? - meow - 12-24-2015

(12-24-2015, 02:21 PM)Retro Wrote: I'm unsure as to what you're trying to accomplish, if you want to grep users credentials use AstroGrep.

You're an idiot.

(12-24-2015, 02:51 PM)Zayzo Wrote: Making big clumsy dbs smaller by only having username:hashalt:email:ip

instead of 0,`, `,etc

If this is what you wanted to do your question should've been something like "how to sort databases", not how to parse them.
You can accomplish that with awk, cut, and sed.