首页 \ 问答 \ 来自bash的简单数据库解决方案(本地存储)(simple database solution (local storage) from bash)

来自bash的简单数据库解决方案(本地存储)(simple database solution (local storage) from bash)

我正在寻找一个简单的数据存储解决方案,从本地bash(写和读)接口。

背景:我正在收集传感器数据并使用时间戳保存值(实际上在文本文件中,每周都会创建一个新文件)。 我喜欢在php的帮助下根据请求可视化数据。 是否有一个可以从bash轻松编写的数据库(如sqlite)?


I am searching for an simple data storage solution, interfaced from local bash (write and read).

Background: I'm collecting sensor data and save values with timestamp (actually in a text file, every week a new file is created). I like to visualize the data on request with the help of php. Is there a database (like sqlite) which can be easily written from bash ?


原文:https://stackoverflow.com/questions/36502268
更新时间:2024-04-25 19:04

最满意答案

把这样的东西放到一个函数中:

$start = strtotime('2014-01');
$end = strtotime('2014-12');
$range = array(date('Y-m', $start) => date('Y-m', $start));
while ( $start <= strtotime('-1 month', $end) ) {
    $start = strtotime('+1 month', $start);
    $yearMonth = date('Y-m', $start);
    $range[$yearMonth] = $yearMonth;
}
var_dump($range);

Put something like this into a function:

$start = strtotime('2014-01');
$end = strtotime('2014-12');
$range = array(date('Y-m', $start) => date('Y-m', $start));
while ( $start <= strtotime('-1 month', $end) ) {
    $start = strtotime('+1 month', $start);
    $yearMonth = date('Y-m', $start);
    $range[$yearMonth] = $yearMonth;
}
var_dump($range);

相关问答

更多
  • 如果您还需要单个文章的名称,则不能使用GROUP BY。 只需获取整个列表,然后按年和月分组。 $sql = "SELECT timestamp, your_id_column, your_title_column FROM `NEWS` ORDER BY timestamp DESC"; $newsdata = DataAccess::ArrayFetch($sql); $nav = array(); foreach ( $newsdata as $news ) { $year = date ...
  • 把这样的东西放到一个函数中: $start = strtotime('2014-01'); $end = strtotime('2014-12'); $range = array(date('Y-m', $start) => date('Y-m', $start)); while ( $start <= strtotime('-1 month', $end) ) { $start = strtotime('+1 month', $start); $yearMonth = date('Y-m' ...
  • 尝试这个: $year = (int)$row['year']; // this comes from a query that is stored in the db ?> 然后你可以将它添加到$(document).ready()函数中 var $years = $("select[name='years']"); for(var i = 1991; i <= 2015; i++) { $years.prepend(""); } If your year select list ...
  • 您不能在group by子句中使用别名。 试试这种方式: select f.name, MONTH(cddh.dateGiven) as date_month, YEAR(cddh.dateGiven) as date_year from calculatedDrugDistributionHistory cddh inner join facilityIndividuals fi on fi.facilityIndividualId = cddh.facilityIndivid ...

相关文章

更多

最新问答

更多
  • 如何在Laravel 5.2中使用paginate与关系?(How to use paginate with relationships in Laravel 5.2?)
  • linux的常用命令干什么用的
  • 由于有四个新控制器,Auth刀片是否有任何变化?(Are there any changes in Auth blades due to four new controllers?)
  • 如何交换返回集中的行?(How to swap rows in a return set?)
  • 在ios 7中的UITableView部分周围绘制边界线(draw borderline around UITableView section in ios 7)
  • 使用Boost.Spirit Qi和Lex时的空白队长(Whitespace skipper when using Boost.Spirit Qi and Lex)
  • Java中的不可变类(Immutable class in Java)
  • WordPress发布查询(WordPress post query)
  • 如何在关系数据库中存储与IPv6兼容的地址(How to store IPv6-compatible address in a relational database)
  • 是否可以检查对象值的条件并返回密钥?(Is it possible to check the condition of a value of an object and JUST return the key?)
  • GEP分段错误LLVM C ++ API(GEP segmentation fault LLVM C++ API)
  • 绑定属性设置器未被调用(Bound Property Setter not getting Called)
  • linux ubuntu14.04版没有那个文件或目录
  • 如何使用JSF EL表达式在param中迭代变量(How to iterate over variable in param using JSF EL expression)
  • 是否有可能在WPF中的一个单独的进程中隔离一些控件?(Is it possible to isolate some controls in a separate process in WPF?)
  • 使用Python 2.7的MSI安装的默认安装目录是什么?(What is the default installation directory with an MSI install of Python 2.7?)
  • 寻求多次出现的表达式(Seeking for more than one occurrence of an expression)
  • ckeditor config.protectedSource不适用于editor.insertHtml上的html元素属性(ckeditor config.protectedSource dont work for html element attributes on editor.insertHtml)
  • linux只知道文件名,不知道在哪个目录,怎么找到文件所在目录
  • Actionscript:检查字符串是否包含域或子域(Actionscript: check if string contains domain or subdomain)
  • 将CouchDB与AJAX一起使用是否安全?(Is it safe to use CouchDB with AJAX?)
  • 懒惰地初始化AutoMapper(Lazily initializing AutoMapper)
  • 使用hasclass为多个div与一个按钮问题(using hasclass for multiple divs with one button Problems)
  • Windows Phone 7:检查资源是否存在(Windows Phone 7: Check If Resource Exists)
  • 无法在新线程中从FREContext调用getActivity()?(Can't call getActivity() from FREContext in a new thread?)
  • 在Alpine上升级到postgres96(/ usr / bin / pg_dump:没有这样的文件或目录)(Upgrade to postgres96 on Alpine (/usr/bin/pg_dump: No such file or directory))
  • 如何按部门显示报告(How to display a report by Department wise)
  • Facebook墙贴在需要访问令牌密钥后无法正常工作(Facebook wall post not working after access token key required)
  • Javascript - 如何在不擦除输入的情况下更改标签的innerText(Javascript - how to change innerText of label while not wiping out the input)
  • WooCommerce / WordPress - 不显示具有特定标题的产品(WooCommerce/WordPress - Products with specific titles are not displayed)