What is your Favorite Tools that you use in relation with BF ?
by asadabi - Friday December 8, 2023 at 03:03 PM
#1
To your keyboards
#2
(Dec 08, 2023, 05:28 PM)litany92 Wrote: cookies !!!

I was expecting something likea python/bash program, or something to parse data, or vscode, ...  Huh
#3
i use C# to make clean csv-files, which i can import to my ms-sql-server. C# can read textfiles line by line and you can split/modify/clean the lines (delete sql-code etc) and write them to a clean-file. and it doesnt matter if the textfile have 1MB or 1TB. and of course you can just use the columns you need. i also use newtonsoft.json in C# for json-content. it parses the data and you can write an output-file as you wish
#4
(Dec 12, 2023, 08:52 PM)leaktroll Wrote: i use C# to make clean csv-files, which i can import to my ms-sql-server. C# can read textfiles line by line and you can split/modify/clean the lines (delete sql-code etc) and write them to a clean-file. and it doesnt matter if the textfile have 1MB or 1TB. and of course you can just use the columns you need. i also use newtonsoft.json in C# for json-content. it parses the data and you can write an output-file as you wish

Waouh! I didn't think about c#. Thanks !

I use bash, for parsing and filtering data in csv files, but I need to split files more than 1Go. (May be I have to increase my swap partition).
Do you think C# more efficiency than bash or other language ?
Recently, I wanted to switch from bash to python using pandas lib.
#5
Hey ! 

I use python to parse the data, its not as fast as somthing like C# but its just much easier.

Once I parse the data, into a JSON like object, I add it to an elasticsearch instance to later query it using a custom interface made in html css and javascript.

I use flask as the middleman, to pass the login creds and handle the user input sanitation. It's still in beta stages.

You can even create profiles on a specific person! Angel
#6
(Dec 14, 2023, 01:08 AM)capital-gains Wrote: Hey ! 

I use python to parse the data, its not as fast as somthing like C# but its just much easier.

Once I parse the data, into a JSON like object, I add it to an elasticsearch instance to later query it using a custom interface made in html css and javascript.

I use flask as the middleman, to pass the login creds and handle the user input sanitation. It's still in beta stages.

You can even create profiles on a specific person! Angel

Waouh ! Interesting. I've never ever used elasticsearch.

Thanks
#7
What about Postgre databases ?
#8
I've a big sql file with non ascii characters almost between every character. Did someone have an Idea to recover the original SQL file ?
I try strings command in linux but it seems to replace the non-ascii chars with breaklines.
#9
(Dec 19, 2023, 01:39 PM)asadabi Wrote: I've a big sql file with non ascii characters almost between every character. Did someone have an Idea to recover the original SQL file ?
I try strings command in linux but it seems to replace the non-ascii chars with breaklines.

show sample of both outputs
#10
Here is a sample of the original file :

Quote:
�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�'�,� �N�'��V�]w'�,� �N�'�WSEQ^'�,� �N�'�z��^:S'�,� �N�'��V�]wWSEQ^z��^:S�e?eN�~f�s\:S1�5�b^2�USCQ'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�'�,� �N�'�Ym_lw'�,� �N�'�mg�]^'�,� �N�'�YOmg:S'�,� �N�'�Ym_lwmg�]^YOmg:STN�SG�TN����1�3�5��S1��S|i'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�'�,� �N�'����[w'�,� �N�'�'Yޏ^'�,� �N�'��ez��S:S'�,� �N�'����[w'Yޏ^�ez��S:S'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�0�'�,� �N�'�_lςw'�,� �N�'�ς�]^'�,� �N�'�8^�q^'�,� �N�'�_lςwς�]^8^�q^W�6e'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�0�'�,� �N�'�_lςw'�,� �N�'�ς�]^'�,� �N�'�s^_l:S'�,� �N�'�_lςwς�]^s^_l:S_lςwς�]^�V:Sς�]'Yf[�r�XVn!h:S�Ng'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�0�'�,� �N�'�_lςw'�,� �N�'�ޏ�N/n^'�,� �N�'�Nwm�S'�,� �N�'�_lςwޏ�N/n^Nwm�S)RlNe�^WS�]8�-�5� N|iN7b'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�0�'�,� �N�'��lSw'�,� �N�'��w�[�^^'�,� �N�'���[:S'�,� �N�'��lSw�w�[�^^��[:S V�c�[�\wm�S�e�W4�b^3�USCQ'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�0�'�,� �N�'����[w'�,� �N�'�'Yޏ^'�,� �N�'��ez��S:S'�,� �N�'����[w'Yޏ^�ez��S:S'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�0�0�'�,� �N�'����[w'�,� �N�'�'Yޏ^'�,� �N�'��ez��S:S'�,� �N�'����[w'Yޏ^�ez��S:S'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�0�0�0�0�0�0�0�'�,� �N�'����[w'�,� �N�'�'Yޏ^'�,� �N�'�u�NP[:S'�,� �N�'����[w'Yޏ^u�NP[:S�tQW�9��S5� 1� 1�'Yޏ^5ul(�ϑ�b/gOSO'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�'�,� �N�'��y�^w'�,� �N�'��S�^'�,� �N�'�Vn̑:S'�,� �N�'��y�^w�S�^Vn̑:S�gVn��1�8�9��S�lNS�]8�"��R�'�)�

�I�N�S�E�R�T� �[�d�b�o�]�.�[�B�i�g�_�1�_�s�h�u�n�f�e�n�g�]� �(�[�n�a�m�e�]�,� �[�p�h�o�n�e�]�,� �[�p�r�o�v�i�n�c�e�]�,� �[�c�i�t�y�]�,� �[�d�i�s�t�]�,� �[�a�d�d�r�]�)� �V�A�L�U�E�S� �(�N�'�'�,� �N�'�0�0�3�1�6�6�6�0�5�6�9�0�'�,� �N�'��lSw'�,� �N�'��w�[�^^'�,� �N�'�eh�:S'�,� �N�'��lSw�w�[�^^eh�:S�w�[�^^�eNS:S݄)Y~�!hWSL�6�0�0�s|S�V��^�g,�M��-N�_7��S�^ ��
N���S0R�N�N�Ts^��S��  �'�)�

Finally I used this command line on linux :

sed 's/[^[:print:]]//g' "file_naeme" | sed 's/\[//g ; s/\]//g' ;


Possibly Related Threads…
Thread Author Replies Views Last Post
  ID gravix 1 150 Feb 10, 2026, 06:27 PM
Last Post: pine
  THIS BOT HAVE +250M DATABASES LEAKS? HackerGod21 1 213 Feb 09, 2026, 03:38 PM
Last Post: pine
  WTB Maillist canada and belgium locklack 3 225 Feb 08, 2026, 08:32 AM
Last Post: Tanaka
  Best database Unstoppable1 1 213 Feb 07, 2026, 03:22 PM
Last Post: pine
  I'm wondering if it's possible to hack a university's online journal? empress098 1 221 Feb 05, 2026, 06:55 PM
Last Post: pine

Forum Jump:


 Users browsing this forum: 1 Guest(s)