Skip to main content

It's Life, What More Do You Want?

This life is here for a reason, we don’t have to say exactly what that reason is, we just have to believe in it no matter what happens in this life, we have to understand one thing. That thing is that we are not alone in the universe. I’m not saying there are aliens out there, but yeah there are aliens out there. It’s a concept that people have wondered about from time to time, there doesn’t appear to be anything else you can do but wonder what’s going on in the skies above us! There are so many things in this life that don’t always seem to matter, but you wish they would, at least that’s what I’d like to think would happen. I’m not sure that’s how this life is meant to be understood of course. If there’s anything in this life that doesn’t make sense, then it will always be there. It doesn’t have to make sense, that’s the absurdity of it all! Why should it make sense if there’s nothing to grasp from it all? I’m not sure I know the ansewr to that question. Such a life comes and goes an...
Post a Comment

Files Table in sql for SQLite3

Here's some code I'm working on for a sqlite3 database to store backup file content. Might add a BLOB type later for storing binary data. Not sure yet.


PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE files (id INTEGER PRIMARY KEY,
 name TEXT,
 content TEXT,
 created_ts TEXT,
 modified_ts TEXT);
CREATE TABLE files_log(id INTEGER PRIMARY KEY,
  fileid TEXT,
  name TEXT,
  content TEXT,
  created_ts TEXT,
  modified_ts TEXT,
  dt TEXT);
CREATE TRIGGER files_trig AFTER INSERT ON files
BEGIN
  update files SET created_ts = datetime('now','localtime') WHERE id = NEW.id;
END;
CREATE TRIGGER files_update_trig AFTER UPDATE ON files
BEGIN
  update files SET modified_ts = datetime('now','localtime') WHERE id = OLD.id;
  insert into files_log(fileid, name, content, created_ts, modified_ts)
    values(OLD.id, OLD.name, OLD.content, OLD.created_ts, OLD.modified_ts);
END;
CREATE TRIGGER files_log_update_trig AFTER INSERT ON files_log
BEGIN
  update files_log SET dt = datetime('now', 'localtime') WHERE id = NEW.id;
END;
COMMIT;
Labels:

Comments

Post a Comment

Popular posts from this blog

Temptation Bible vs Book of Mormon

In the Bible in 1 Corinthians 10:13 we find: There hath no temptation taken you but such as is common to man: but God is faithful, who will not suffer you to be tempted above that ye are able ; but will with the temptation also make a way to escape, that ye may be able to bear it. But what might seem as a contradiction is found in Alma 13:28 But that ye would humble yourselves before the Lord, and call on his holy name, and watch and pray continually, that ye may not be tempted above that which ye can bear , and thus be led by the Holy Spirit, becoming humble, meek, submissive, patient, full of love and all long-suffering; So, which is it? Either God tempts you to a point and stops, or you have to actively pray not to be tempted beyond that no return point. Which is it?
Post a Comment
Read more

Didn't Sleep

 What's the point of sleep anymore if I can't sleep? I don't think I slept any good last night. I was awake at 3 am wondering to myself, what on earth am I doing awake? Yeah, that happened. It doesn't make any sense. Fortunately, it's the weekend. So, I can catch up on sleep tonight. I don't have to be anywhere tomorrow, so it's a good opportunity to actually sleep for once. Whatever the case, I hope I'll be able to fall asleep and stay asleep. We will see what happens.
Post a Comment
Read more

An Opposition In All Things

Long has been the story told about how there must be an opposition in all things. From the pre-existence there was Satan, Lucifer the Son of the Morning. In the beginning we were with God in his presence. We learned all we could while there. Until the moment we couldn’t progress any more, we were unable to become like God. So, we were given the opportunity to come to Earth to gain a body. A Savior would be provided to atone for our sins enabling us to come back to the presence of God. The idea that an opposition must be in all things comes from 2nd Nephi: For it must needs be, that there is an opposition in all things. If not so, my firstborn in the wilderness, righteousness could not be brought to pass, neither wickedness, neither holiness nor misery, neither good nor bad. Wherefore, all things must needs be a compound in one; wherefore, if it should be one body it must needs remain as dead, having no life neither death, nor corruption nor incorruption, happiness nor misery, neither...
Post a Comment
Read more