Skip to content

Instantly share code, notes, and snippets.

View georgecatalin's full-sized avatar
🇷🇴

George Calin georgecatalin

🇷🇴
View GitHub Profile
@georgecatalin
georgecatalin / .vimrc
Created March 18, 2024 12:11
Customize VIM for bash scripting
# customizations to add so that VIM suits best bash scripting
set number
set showmatch
syntax enable
set autoindent
set smartindent
@georgecatalin
georgecatalin / md
Created March 18, 2024 10:04
How to set a VIM with a Oracle VM VirtualBox running on an AMD processor machine
Access the VM location
Open CMD
Use the following command (replace YOUR_VM_NAME with your VM name):
vboxmanage setextradata YOUR_VM_NAME VBoxInternal/CPUM/HostCPUID/80000006/edx 0x02009140
@georgecatalin
georgecatalin / an_example_of_local.conf
Last active December 1, 2020 09:59
An example of content for local.conf file needed when building with Yocto Project
#################################################################################################################
# An example of local.conf modified by George Calin george.calin@gmail.com , on 1st of December 2020
# This local.conf supports Qt libraries and various other utilities (GStreamer, etc)
# The local.conf is tested and runs on Yocto 3.1 dunfell, and most likely with all versions until Yocto 2.6 Thud
# Pre Thud (Yocto 2.6) compatibility of each package and the local.conf structure has to be verified
##################################################################################################################
# You need to select a specific machine to target the build with. There are a selection
# of emulated machines available which can boot and run in the QEMU emulator:
#
#MACHINE ?= "qemuarm"
@georgecatalin
georgecatalin / gist:11fcabe44fb663b5f510677d9d938073
Last active August 9, 2020 11:47
How to extract data from SQL Server database and display it with Microsoft Excel and VBA
Public Sub GetData_from_SQLServerDatabase_with_VBA_Excel()
Dim strConnectionString As String, strQuery As String, strMessage As String
Dim objConn As ADODB.Connection
Dim rsData As ADODB.Recordset
Dim varArrayReader As Variant
Dim intLBoundColumn As Integer, intUBoundColumn As Integer ' this variable is meant to hold the lower and upper indexes of the 1st dimension of the Array (columns)
Dim intLBoundRow As Integer, intUBoundRow As Integer ' this variable is meant to hold the lower and upper indexes of the 2nd dimension of the Array (rows)
Dim i As Integer, j As Integer
@georgecatalin
georgecatalin / gist:1c35fb80b95e648a443ea8011125d8ed
Created August 9, 2020 08:32
How to extract data from SQL Server database and display it with Microsoft Excel and VBA
Public Sub GetData_from_SQLServerDatabase_with_VBA_Excel()
Dim strConnectionString As String, strQuery As String, strMessage As String
Dim objConn As ADODB.Connection
Dim rsData As ADODB.Recordset
Dim varArrayReader As Variant
Dim intLBoundColumn As Integer, intUBoundColumn As Integer ' this variable is meant to hold the lower and upper indexes of the 1st dimension of the Array (columns)
Dim intLBoundRow As Integer, intUBoundRow As Integer ' this variable is meant to hold the lower and upper indexes of the 2nd dimension of the Array (rows)
Dim i As Integer, j As Integer
@georgecatalin
georgecatalin / Getting started with Qt and Qt Creator on Linux
Last active June 26, 2021 22:42
Instructions for installing Qt and Qt Creator on Linux
https://www.ics.com/blog/getting-started-qt-and-qt-creator-linux
step 1: $ sudo apt-get install build-essential libgl1-mesa-dev
step 2: sudo apt install gdb
step 3:
$ cd ~/Downloads
$ chmod a+x qt-unified-linux-x64-2.0.3-1-online.run
@georgecatalin
georgecatalin / Commands_for_EF_in_PackageManagerConsole_VisualStudio.txt
Last active January 16, 2020 11:11
Commands in Package Manager Console of Visual Studio associated with Entity Framework
enable-migration
!!! Asigura-te ca este setat proiectul care contine referinta la Entity Framework in console
add-migration
!!! Creeaza clasele si codul .cs pentru migrarea datelor. Se utilizeaza un API C# care descrie in C# ce va aparea in SQL mai tarziu
update-database -script !!! Creeaza un fisier care contine codul T-SQL pentru construirea bazei de date si a tabelelor conform migrarii
ori
update-database -verbose !!! Efectueaza modificarile conform cu informatiile de migrare direct in baza de date.