Assuming you understand the consequences of using the MEMORY engine as mentioned in comments, and here, as well as some others you’ll find by searching about (no transaction safety, locking issues, etc) – you can proceed as follows: MEMORY tables are stored differently than InnoDB, so you’ll need to use an export/import strategy. First dump … Read more
In case your CSV is quite large, using INSERTS is very ineffective. You should use a bulk loading mechanisms, which differ from base to base. E.g. in PostgreSQL you should use “COPY FROM” method: with open(csv_file_path, ‘r’) as f: conn = create_engine(‘postgresql+psycopg2://…’).raw_connection() cursor = conn.cursor() cmd = ‘COPY tbl_name(col1, col2, col3) FROM STDIN WITH (FORMAT … Read more
The point is that Optimistic Locking is not a database feature, not for MySQL nor for others: optimistic locking is a practice that is applied using the DB with standard instructions. Let’s have a very simple example and say that you want to do this in a code that multiple users/clients can run concurrently: SELECT … Read more
The datawrangling blog posted a nice list a while back: http://www.datawrangling.com/some-datasets-available-on-the-web Includes financial, government data (labor, housing, etc.), and too many more to list here.
First check if it’s a workbench or connection problem. 1) In your windows run ‘cmd’ to open a terminal Try both 2a) mysql -u root -p -h 127.0.0.1 -P 3306 2b) mysql -u root -p -h > localhost -P 3306 3) If the connection is good you will get a password prompt, see if you … Read more
Short story about serialization After many years of hard work, Earth’s scientists developed a robot who can help them in daily work. But this robot had fewer features than the robots developed by the scientists from planet Mars. After a meeting between both planets’ scientists, it is decided that Mars will send their robots to … Read more
JCR repositories are different than RDBMSes, because a JCR repository: is hierarchical, allowing your to organize your content in a structure that closely matches your needs and where related information is often stored close together and thus easily navigated is flexible, allowing the content to adapt and evolve, using a node type system that can … Read more
You’ve just answered your own question 🙂 You can do something like this: $query = $this->db->get(); $ret = $query->row(); return $ret->campaign_id; You can read more about it here: http://www.codeigniter.com/user_guide/database/results.html
Launch MySQL Workbench. On the left pane of the welcome window, choose a database to connect to under “Open Connection to Start Querying”. The query window will open. On its left pane, there is a section titled “Object Browser”, which shows the list of databases. (Side note: The terms “schema” and “database” are synonymous in … Read more
Backup your databases docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y”_”%H_%M_%S`.sql Restore your databases cat your_dump.sql | docker exec -i your-db-container psql -U postgres