Phil Gyford philgyford

Migrating a Django postgresql database to sqlite3

I wanted to export data from a few Django apps, held in a postgres database, and import that data into an sqlite3 database to run locally.

This worked for me, but I'm sure there are other wrinkles, depending on your use of postgres-specific features, etc.

Export the data from postgres

Django Find and Replace

This was used to replace all the instances of old Media URLs with new ones, but could be used for any kind of text search/replace across Django objects.

Change the model import to whatever your app and model is.
Set the to_find and to_replace strings to whatever you need.
Change Post to your model name, and the fields to whatever field(s) you want to search and replace across.

	from ckeditor.widgets import CKEditorWidget
	from django import forms
	from django.contrib import admin
	from django.db import models
	from django.utils import timezone

	from .models import Post


	class PostAdminForm(forms.ModelForm):

	<?php
	/**
	* Plugin Name: List Custom Taxonomy Widget
	* Plugin URI: http://celloexpressions.com/plugins/list-custom-taxonomy-widget
	* Description: Widget that displays category listings for custom post types (custom taxonomies).
	* Version: 4.1
	* Author: Nick Halsey
	* Author URI: http://celloexpressions.com/
	* Tags: custom taxonomy, custom tax, widget, sidebar, category, categories, taxonomy, custom category, custom categories, post types, custom post types, custom post type categories
	* License: GPL

	<?php
	add_action( 'wp_enqueue_scripts', 'my_theme_enqueue_styles' );
	function my_theme_enqueue_styles() {

	$parent_style = 'sparkling-style'; // This is 'sparkling-style' for the sparkling theme.

	wp_enqueue_style( $parent_style, get_template_directory_uri() . '/style.css' );
	wp_enqueue_style( 'child-style',
	get_stylesheet_directory_uri() . '/style.css',
	array( $parent_style ),

	{% extends "base.html" %}

	{% block content %}

	<p>(Article content here.)</p>

	<p>Send us your thoughts:</p>

	<form action="{% pageurl page %}" method="POST">
	{% csrf_token %}

	license: cc-by-sa-4.0
	height: 1200
	scrolling: no
	border: yes

	#!/usr/bin/env python2.7

	import subprocess
	import sys
	import re
	import os,pwd
	from pprint import pprint

	class TerminalController:
	"""

	images/*
	*.csv