Aybars Acar AybarsAcar

Java Hibernate/Sqlite Example

Dependencies

// https://mvnrepository.com/artifact/org.hibernate/hibernate-core
compile group: 'org.hibernate', name: 'hibernate-core', version: '5.2.16.Final'

// https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc
compile group: 'org.xerial', name: 'sqlite-jdbc', version: '3.21.0.1'

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

	CLIENT SIDE:

	#include <iostream>
	#include <winsock2.h>
	using namespace std;

	#pragma comment(lib,"ws2_32.lib") // підключення бібліотеки winsock
	#pragma warning(disable:4996)

	#define SERVER "127.0.0.1" // ip-адреса сервера (локальний хост)