Deleting Facebook

2017-01-302017-01-30 by Damon Caskey

Recently as I go deeper into the academic rabbit hole, I have found the need to revive my blog just a bit. Many class assignments require writing up discussion points, so why not do it here?

Also, if I am to eventually obtain a PHD, it is important to build a body of work. Some of the none of you reading this may have noticed an influx of posts about various functions, database manifests, and so on. These are partially just notes so I can remember what I was doing five minutes ago – but eventually along with my OpenBOR work I am hoping to have a nice collection to organize and publish.

So what does this have to do with Facebook? Simple, part of reviving the blog sphere means reorganizing – switching to hashtags vs. loads of categories, revamping some old code, all that good business.

As it happens, Facebook is chained to this thing like Stevie Nicks, ergo my account needs cleaning just as bad. Fixing the albums, categorizing posts so I can find them, and frankly, removing a few faux pas. Not personal stuff – I was always pretty careful about that. I’m talking posts about code work that looking back now I must wonder what sick malaise struck me when crafting them! 🙂

Problem is have you SEEN what a pain it is to clean FB profiles?! Mine has been active since 2008, and I no doubt averaged ~1.5 posts a day. That’s a lot of extraneous excrement to sift through. It’s certainly doable, just not worth the time. Instead let’s go the way of a rookie call center tech: Format and recover!

Within the next week I am going to perform a full delete on my account. Afterwards I will restart fresh, though it might be a while since FB can take up to 90 days before a profile is truly cleared.

There you have it – sorry if I carried on like an Allen Collins solo. If you see me show up as a friend request in the next month or two, it’s really me and I hope you’ll accept. In the meantime, both of you who wish to keep up with me may do so here or through my other social venues. You shouldn’t have trouble finding them.

See you soon!

PHP Directory Scan

2017-01-302017-01-30 by Damon Caskey

Introduction

This function will scan directories and return keyed arrays of file attributes matching a user provided filter string. Perfect for image, documents, and other sorts of content delivery where a naming convention is known but the directory contents are often appended or otherwise in flux.

Example

Let’s assume we need to locate a series of .pdf newsletters. Occasionally these letters are uploaded to the web server with a big endian date based naming convention.

The documents we need might be part of a larger container with many other items.

Since we know each file begins with “bio_newsletter_”, we can use that as our search string, like this:

$directory 			= '/docs/pdf/';
$filter				= 'bio_newsletter*/';
$attribute			= 'name';
$descending_order 	= TRUE;

$files = directory_scan($directory, $filter, $attribute, $descending_order);

The function will then rummage through our target directory, and return an array with any matched files, giving you an output that looks something like this:


Key	Value
/docs/pdf/bio_newsletter_2015_09.pdf	/docs/pdf/bio_newsletter_2015_09.pdf
/docs/pdf/bio_newsletter_2015_05.pdf	/docs/pdf/bio_newsletter_2015_05.pdf
/docs/pdf/bio_newsletter_2015_04.pdf	/docs/pdf/bio_newsletter_2015_04.pdf
…

This might look redundant, but that’s because keys are always populated with file name to allow extraction of values by name later, and in this case we are looking specifically for the file name. There is an option of returning one of several attributes, which are reflected in the value.

If the directory does not exist or isn’t readable, the function will return NULL.

Source

// Caskey, Damon V.
// 2012-03-19
//
// Scan a directory for files matching filter
// and return an array of matches.
//
// $directory: 		Directory to scan.
// $filter:		Filter string.
// $attribute:		File attribute to acquire. See here for 
// 			list of available attributes: http://php.net/manual/en/function.stat.php
// $order_descending:	FALSE (default) = Order by file name ascending. 
//			TRUE = Order by file name descending. 
function directory_scan($directory, $filter, $attribute = 'name', $order_descending = FALSE)
{	
    $result 			= NULL;	// Final result.
    $directory_handle 	= NULL; 	// Directory object handle.
	$directory_valid	= FALSE;	// If directory is accessible.
	$stat				= array();	// Attribute array.
	
	// Validate directory.
	$directory_valid = is_readable($directory);
	
	// If the directory is valid, open it
	// and get the object handle.
	if($directory_valid)
	{
		$directory_handle = opendir($directory);
	}
	
	// Do we have a directory handle?
	if($directory_handle) 
	{
		// Scan all items in directory
		// and populate result array with 
		// the attribute of those with
		// names matching our search pattern.
        do 
		{
			// Get first/next item name in the 
			// directory handle.
			$file_name = readdir($directory_handle);
			
			
            if (preg_match($filter, $file_name)) 
			{
                $stat = stat($directory.'/'.$file_name);
				
				// If requested attribute is name, then
				// just pass on the name with directory.
				// Otherwise, pass the requested attribute.
				if($attribute == 'name')
				{
					$result[$file_name] = $file_name;
				}
				else
				{
					$result[$file_name] = $stat[$attribute];
				}
            }
			
        }
		while($file_name !== FALSE);
        
		// Close the directory object.
		closedir($directory_handle);
        
		// Sort the array as requested.
		if ($order_descending)
		{
            arsort($result);
        }
        else
		{
            asort($result);
        }
    }
	
	// Return resulting array.
    return $result;
}

A word of caution – directory scanning is simple and effective, but doesn’t scale so well. A few hundred files is fine, but once you start breaching the thousands it’s probably time to break your directory structure down a bit, or consider a RDMS solution.

Until next time!

Social Media And Charitable Initiatives

2017-01-282017-02-06 by Damon Caskey

Contents

Introduction

One of the greatest potentials of social media is that of logistics. No need for daisy chain calls, large scale meetings, or travel. Just fire up a space in your application of choice and go. As mentioned here however, the almost comical ease of joining a cause has potential challenges of its own.

Articles

Questions

Q1 – Discuss social initiatives vs. social media.

One of the potential dangers of contemporary social media is the lack of effort required to conceive any sort of cause or initiative. With just a few well placed words or photos, one person can stir a whirlwind of frenzied interest and passion. Yet, just as quickly these movements fizzle out to be replaced with a new interest.

It is of course possible to circumvent this pitfall, creating a true initiative rather than a viral burst. It is my opinion the subtler, more meaningful approach that produces long term effort is what separates a functioning initiative from common social media.

Q2 – How can social media be used to empower a charitable initiative?

On the most basic level, social media is the ultimate logistical tool. I can attest from personal experience. My peers have at times arranged missing person searches, training, tornado clean up, flood aid, and even funeral support.

Social media is also a powerful potential fundraising tool. In the time a single person might canvas one neighborhood for support, social media could potentially reach millions.

Power of Social Media

2017-01-262017-01-30 by Damon Caskey

Contents

Introduction

Continuing discussion of defining social media. The first in class discourse confirmed (at least personally) my theory of social media: That it is largely a psychological construct. Each individual responded with a definition that reflected their own experiences and predilections. This is not a bad thing at all, and in my opinion demonstrates the true power of social media – diversity and awareness.

Articles

Questions

Q1 – What is the true power of social media?

Numbers don’t lie – social media is ubiquitous in society. But how much of an effect does it really have? Consulting groups are quick to assure a social media presence is essential to any business survival, and for brand awareness they may well be on target. In terms of direct sales – perhaps not so much. Facebook’s entire business model is a hedge bet by advertisers not yet backed up by quantifiable results in product sales. Essentially it’s a repeat of the dot-com model (and we all know how that one went).

Conversely though, the psychological power of social media is undeniable. As above, you may not sell more widgets by placing ads on Facebook, but it’s likely you won’t sell any widgets AT ALL without a social media presence.

In short, awareness is the key.

Q2 – What are the personal effects of social media?

How many of us in the first world make a day without checking our favorite social media site? Good old stand by example Facebook is last week’s news in the public consciousness, scoffed at my millennials, derided by Gen-X, loathed by boomers. Yet ~10% of the entire world’s population logs in each day. Nobody on Facebook anymore? Somebody’s lying.

The impact is enormous, and effects it has on everyday lives are obvious. For this question, I will focus on what is perhaps the most oft debated aspect: Privacy.

I’ve made no secret about my view that social media gets overstated a bit. Facebook and its ilk get credit (and blame) for a lot of concepts they neither invented or refined. Data mining? Please. Entities like Equifax know more about us than Zukerburg could ever imagine – and have been at it since 1899. That’s not a typo: 1899! Blaming social media for breach of privacy is no more fair than giving it credit for empowering movements in society. What has social media done then?

See also: Public awareness. Sure, there’s still the common misconception data mining is a new thing, but at least we now have a public awareness that it does in fact exist. Moreover, though social media does make data mining hilariously easy, it also gives John-Q a tool to push back with, if only just a little.

This awareness of social media I believe is far and away more powerful than the social media itself. The illusion or in some cases reality that we are watched by peers undeniably alters our every day human behavior (deny it, go ahead). I would like to delve further into the topic of awareness via in person discussion, as breaching here would need far more than allotment of one page.

Cammy White

2017-01-242017-01-24 by Damon Caskey

This blog has been long overdue for cleaning, and with discussion based classes kicking into gear its going to see quite a bit of mileage soon. Housecleaning includes unused media files, and oh boy are there plenty! One of the first items I discovered was a huge pile of photos acquired 2015-01-12 while taking a GSD named Cammy out for her first Winter.

Regardless of what some Winter haters may tell you, big snows in Kentucky are pretty rare and usually concentrated in a small area. I thought catching a good one in the Red River Gorge was lighting in a bottle, at least until the blizzard of 2015 blew it away, and the blizzard of 2016 blew THAT away. Alas, it looks as if 2017 will bring no such luck.

In any case, here are the shots. Better five years late than never, ne?

What IS Social Media?

2017-01-242017-01-24 by Damon Caskey

Social Media (Wikipedia)

History And Evolution of Social Media

What is social media? Ask Mr. John Q., and you will probably get something akin to “Facebook”, “Twitter”, or whatever the most prominent brand is at the moment. That’s a fine example of branding yes? Those are no more the definition of Social Media than “Kleenex” is the definition for tissue. Or are they? Social media is social is it not? If the public consciousness says that social media is Facebook and Twitter, perhaps it is.

According to Wikipedia, social media is defined as follows…

Social media are computer-mediated technologies that allow the creating and sharing of information, ideas, career interests and other forms of expression via virtual communities and networks.

…and then immediately admits this definition is neither definitive or all encompassing. It is likely well beyond the scope of this class, let a lone a single discussion to truly define social media, but we can at least narrow the scope a bit with some simple questions.

Q1 – How does “Social Media” differ from other communication vectors?

Technically speaking, telephones are social media, as would be virtually any form of direct communication in the modern era. What exactly sets apart the concept of social media vs. mass media, vs. a simple phone call? One to many? That’s been around since the days of town criers. Instant access? The telegraph. Two way? Telephone.

Could it be the combination of these aspects that creates the “social” in social media? Or is this merely a psychological effect of the previously mentioned branding?

Q2 – What is the future of social media?

Nebulous though it may be, the history of social media is recorded and available for dissemination. A more difficult question is where it will go. Facebook and its ilk are ubiquitous today, but will not last forever. What will replace the current forms of social media? Will blogs like this make a comeback in the public consciousness? Will a new brands come along doing the same thing with another name plate? Or is there a truly disruptive force on the horizon?

Bootstrap Remote File Models

2017-01-232017-01-26 by Damon Caskey

Introduction

Opening a model is well documented for the bootstrap framework, assuming the model’s contents are located within the same document. However, if the model target is a remote file the process becomes slightly more nebulous. After some experimenting and Stack Overflow research I have compiled the following steps to do so.

Link

The link for opening a model must still target a container element of some sort, typically a DIV id. You may also choose to target the container by class. For remote files, you need to include a href as well, targeting the remote file location.

<a href="model_document.php" data-target="#model_div_container_id" data-toggle="modal">Open Model</a>

Model Container

Next you need to prepare the calling document (the same document that contains model link) with a model container. This is exactly the same as with a normal model, except you are only adding the model’s container elements, not its content.

<div class="modal fade" id="#model_div_container_id">
    <div class="modal-dialog">
        <div class="modal-content">
        	<!-- Model content area - leave this empty.-->
        </div>
    </div>
</div>

Model Document (Content)

The last step is to prepare your remote document. Add whatever content you wish. The only special caveat to consider is you do NOT add the model container elements to this document. You only add the content. The content itself may include its own container elements, formatting, and so forth. In the example below, the model is a simple list, and therefore only the markup for the list is included.

<ul>	
    <li>Item 1</li>
    <li>Item 2</li>
    <li>Item 3</li>
</ul>

You’ve probably already guessed what’s going on here. When the model link is clicked, the remote document’s contents are inserted into the calling document’s target element. Bootstrap Model Documentation (extracted 2017-01-23):

If a remote URL is provided, content will be loaded one time via jQuery’s load method and injected into the .modal-content div. If you’re using the data-api, you may alternatively use the href attribute to specify the remote source.

This is why you must include a target element in the calling document, and conversely NOT include model containers in the remote document. Hope this helps. Special thanks to Buzinas from Stack Overflow.

Until next time!

Redefining Political Communication Continued

2017-01-192017-01-24 by Damon Caskey

Original Article (UK Canvas)

Further discussion upon previous points raised here resulted in a slightly more concrete debate of social media and political sphere. One aspect is the delivery system, and thus raises my first query:

Q1 – What are the political effects of connection delivery initials such as Connect Kentucky.

Just like the physical Superhighway system that preceded it, the internet was born from a military initiative. And like the Super Highway system the internet was quickly appropriated by civilian interests, bringing information, commerce, and connections at speeds never conceived.

Unfortunately, parallels continue to the detrimental aspects. The super highway system is often blamed for the disruption and ultimately destruction of areas is bypassed or in the case of larger urban areas, dissected. Without access, the disenfranchised fell yet further behind. So far the internet has proven no different. The poor and uneducated are now being left behind on the virtual highway.

Connect Kentucky and similar initiatives hope to ameliorate the connection disparity by bringing WIFI services to every municipality. Leaving out the logistical obstacles, my immediate would be the potential political ramifications. Someone has to pay for all that hardware, maintenance, and access. Paying is power, and power is control. When public access becomes not a convenience, but a dependence, the dangers of single entity control are very real.

Q2 – What are the drawbacks to a fully connected political sphere?

Quick query? When was the last time you recall any grass-roots movement affecting practical change? I’ve oft heard crowing from social media pundits of the power it gives groups to conduct movements and change the political landscape in ways not possible. However, the last time I checked, there was no such thing as Facebook during the movements for Anti Slavery, Civil Rights, Women’s Suffrage, or any other initiative that actually managed a permanent change in our political sphere.

Indeed, an argument could be made that instant access to group communication, and the ability to “join” a movement by pressing Like or posting a random meme has in fact weakened influence of grass-roots initiatives. To put it bluntly, it takes no effort to make one’s self feel involved without actually doing anything. Outrage comes, goes, and the powerful ignore them until they go away, knowing full well a new flash in the pan distraction will appear tomorrow.

Redefining Political Communication

2017-01-162017-01-17 by Damon Caskey

Original Article (UK Canvas)

The overarching theme appears to be that of political and consumptive entities re-adapting to “new-media”.

Q1. Does any adaptation need to be made at all?

While it is true information is more fragmented and entities must compete in ever wider arenas, an opposing argument could be made politics is business as usual. The splitting trend of ideology continues at an arguably accelerated rate, while third parties, theoretically empowered by new media hold less sway at the polls than they they once did even before the rise of television.

Q2. How best to consolidate the influx of information?

A growing issue with evolving media is that of the common vernacular: “Information overload”. Perhaps though, a more fitting appellation is “input overload”. Twitter, Facebook, Instagram, Snapchat, Tumbler, Google, the blog sphere, all these and many more vie for increasing shares of a finite resource – attention. Add to that ever evolving techniques for insertion of advertising and subjectivity into all forms of media new or old. The end result is a potentially horrifying mix of misinformation and utter consumer apathy.

So what then is the best technique to resolve or at least slow the tide. Technology solutions range from the mundane concepts of auto dissemination up to disruptive new innovations hoping to change the way we access information. Consolidate your news feed to one coherent screen from dozens of sources today – download a filtered stream directly to your conscious tomorrow.

If that sounds far fetched – it is. Technology is nebulous and ever changing. Each generation tends to pat itself on the back for sitting on the bleeding edge while laughing at the poor Luddites who came before – only to be the next laughing stock tomorrow. So it goes that we’re unlikely to find a permanent solution using technology alone.

Perhaps regulatory? I’m not sure I’d even want to breech thins one – freedom of the press, for all the issues it enables, is a necessity to maintaining a reasonably free society.

This in my opinion only leaves the individual to assume responsibility. It is in turn up to us as a whole society to educate ourselves and upcoming generations to view all sources with a critical eye and open mind at once.

Server Side Paging – MSSQL 2008

2017-01-122017-01-23 by Damon Caskey

Introduction

Paging is almost perfunctory when dealing with large lists of online data. Problem is, most paging solutions out there (at least those I’ve seen) perform this vital function on the client side – either through dangerous dynamic SQL or even worse – pulling the entire record set down and disseminating pages for the user afterward.

You wouldn’t (I hope) trust the client to put data into your tables, so why trust it to filter and page? That’s what your database engine was specifically designed to do! Server side paging gives you a couple of big advantages:

Security – See above. I would never, and will never trust a client generated SQL. You’re just asking for it.
Scaling – Client side record processing may seem faster at first because of the instant response. Then your record count passes the VERY modest six digit mark, and suddenly you’re looking for ways to mediate ten minute load times.

The only real downsides to sever side paging are reloading and complexity of initial setup. The former can be dealt with using an AJAX or similar solution. The later is where I come in. The following stored procedure completely encapsulates paging, all of any other data extraction.

Implementation

Execute within data procedure after all other record processing is complete on the primary data table. Assumes primary data is in temp table #cache_primary. Pass following arguments:

page_current – Current record page to view as requested by control code.
page_rows (optional, uses default value if NULL) – Number of rows (records) to output per page.

Outputs following record set for use by control code:

Column	Type	Description
row_count_total	int	Total number of rows in the paged record set.
page_rows	int	Maximum number of rows per page. Will be same as the maximum row argument passed form control code unless that argument was null, in which case this will reflect the default maximum rows.
page_last	int	Last page number / total number of pages.
row_first	int	ID of first record in requested page.
row_last	int	ID of last record in requested page.

SQL

-- Master Paging
-- Caskey, Damon V.
-- 2016-07-08
--
-- Output recordset in divided pages. Also creates and outputs
-- a recordset of paging data for  control code. Execute in another 
-- stored procedure after all other record work (filters, sorting, joins, etc.) 
-- is complete. Make sure final table variable name is #cache_primary.

-- Set standard ISO behavior for handling NULL 
-- comparisons and quotations.
ALTER PROCEDURE [dbo].[master_paging]
    
    -- Parameters. 
        @param_page_current    int            = 1,    -- Current page of records to display.
        @param_page_rows    smallint    = 25    -- (optional) max number of records to display in a page.
            
AS
BEGIN
    
    -- If non paged layout is requested (current = -1), then just
    -- get all records and exit the procedure immediately.
        IF @param_page_current = -1
            BEGIN
                SELECT *
                    FROM #cache_primary
                    RETURN
            END 

    -- Verify arguments from control code. If something
    -- goes out of bounds we'll use stand in values. This
    -- also lets the paging &quot;jumpstart&quot; itself without
    -- needing input from the control code.
                
        -- Current page default.
        IF    @param_page_current IS NULL OR @param_page_current &lt; 1
            SET @param_page_current = 1
            
        -- Rows per page default.
        IF    @param_page_rows IS NULL OR @param_page_rows &lt; 1 SET @param_page_rows = 10 -- Declare the working variables we'll need. DECLARE @row_count_total int, -- Total row count of primary table. @page_last float, -- Number of the last page of records. @row_first int, -- Row ID of first record. @row_last int -- Row ID of last record. -- Set up table var so we can reuse results. CREATE TABLE #cache_paging ( id_row int, id_paging int ) -- Populate paging cache. This is to add an -- ordered row number column we can use to -- do paging math. INSERT INTO #cache_paging (id_row, id_paging) (SELECT ROW_NUMBER() OVER(ORDER BY @@rowcount) AS id_row, id FROM #cache_primary _main) -- Get total count of records. SET @row_count_total = (SELECT COUNT(id_row) FROM #cache_paging); -- Get paging first and last row limits. Example: If current page -- is 2 and 10 records are allowed per page, the first row should -- be 11 and the last row 20. SET @row_first = (@param_page_current - 1) * @param_page_rows SET @row_last = (@param_page_current * @param_page_rows + 1); -- Get last page number. SET @page_last = (SELECT CEILING(CAST(@row_count_total AS FLOAT) / CAST(@param_page_rows AS FLOAT))) IF @page_last = 0 SET @page_last = 1 -- Extract paged rows from page table var, join to the -- main data table where IDs match and output as a recordset. -- This gives us a paged set of records from the main -- data table. SELECT TOP (@row_last-1) * FROM #cache_paging _paging JOIN #cache_primary _primary ON _paging.id_paging = _primary.id WHERE id_row &gt; @row_first 
                AND id_row &lt; @row_last
                    
            ORDER BY id_row    
                
    -- Output the paging data as a recordset for use by control code.
                
        SELECT    @row_count_total    AS row_count_total,
                @param_page_rows        AS page_rows,
                @page_last            AS page_last,
                @row_first            AS row_first,
                @row_last            AS row_last
            
        
END

Master Table Design

2017-01-102017-01-23 by Damon Caskey

Introduction

Master table layout and creation. The master table controls all data tables via one to one relationship and carries audit info.

Layout

Column	Type	Description
id	int (Auto Increment)	Primary key for master table. All data tables must include an ID field (NOT auto increment) linked to this field via one to one relationship.
id_group	int	Version linking ID. Multiple entries share an identical group ID to identify them as a single record with multiple versions. If no previous versions of a new record exist, then this column is seeded from ID field after initial creation.
active	bit	If TRUE, marks this entry as the active version of a record. Much faster than a date lookup and necessary for soft delete.
create_by	int	Account creating this version. -1 = Unknown.
create_host	varchar(50)	Host (usually IP provided by control code) creating entry.
create_time	datetype2	Time this entry was created.
create_etime	Computed column	Elapsed time in seconds since entry was created.
update_by	Same as create_x, but updated on every CRUD operation.
update_host
update_time
update_etime

Set Up

CREATE TABLE [dbo].[_a_tbl_master](
	id				int IDENTITY(1,1)	NOT NULL,						-- Primary unique key.
	id_group		int					NULL,							-- Primary record key. All versions of a given record will share a single group ID.
	active			bit					NOT NULL,						-- Is this the active version of a record? TRUE = Yes.
		-- Audit info for creating version. A new 
		-- version is created on any CRUD operation 
		-- in the data tables controlled by master.
	create_by		int					NOT NULL,						-- Account creating this version. -1 = Unknown.
	create_host		varchar(50)			NOT NULL,						-- Host (usually IP from control code) creating version. 
	create_time		datetime2			NOT NULL,						-- Time this version was created. 
	create_etime	AS (datediff(second, [create_time], getdate())),	-- Elapsed time in seconds since creation.	
		-- Audit information for updating version.
		-- When any CRUD is performed on a data
		-- table, the previously active version
		-- is marked inactive. Deleting a record
		-- simply marks all versions inactive.
		-- In short, the only updates made to 
		-- a master table are toggling Active
		-- flag.
	update_by		int					NOT NULL,						-- Account updating this version. -1 = Unknown.
	update_host		varchar(50)			NOT NULL,
	update_time		datetime2			NOT NULL,
	update_etime	AS (datediff(second, update_time, getdate())),
 
CONSTRAINT PK__a_tbl_master PRIMARY KEY CLUSTERED 
(
	id ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE _a_tbl_master ADD CONSTRAINT DF__a_tbl_master_active		DEFAULT ((1))			FOR active
GO

ALTER TABLE _a_tbl_master ADD CONSTRAINT DF__a_tbl_master_create_by		DEFAULT ((-1))			FOR create_by
GO

ALTER TABLE _a_tbl_master ADD CONSTRAINT DF__a_tbl_master_create_host	DEFAULT (host_name())	FOR create_host
GO

ALTER TABLE _a_tbl_master ADD CONSTRAINT DF__a_tbl_master_created		DEFAULT (getdate())		FOR create_time
GO

ALTER TABLE _a_tbl_master ADD CONSTRAINT DF__a_tbl_master_update_host	DEFAULT (host_name())	FOR update_host
GO

Hashtag Hunting

2017-01-082017-01-22 by Damon Caskey

Hashtags are a great tool – assuming they actually are used as a tool and not containers for pithy phrases and meme overload. As time passes I have found myself sometimes forgetting my own tags, and thus am creating this list to avoid and overlap.

#courthouse_courtship